Hi,

I'm using dreamweaver mx, asp/vbscript and ms access.

Now i have developed a CMS with the ability to add multiple users.

Now how do i lock a particular record that has been opened by another user for editing.

So if the record was already opened by one user, it would tell the second user trying to access the same record that it was already being edited.

Thanks in advance.

Wow,

I have never dealt with this before. I would think that you could add a true/false column to the table in question. Everytime a record was requested you could check to see its status true/false and if it is set to false, do an update query that sets it to true. Once the file is updated set the true/false back to false.

The only flaw I see in this is that if a person only looks at the record and doesn't update it, your record will be locked as true. Would probably then need a way to administer the true/false of each record.

This is my thought.

open a book on application developing and quit spamming the board...

wdglide, you think i have the time to mess around with the board and spam it, sorry if you think that, but im just trying to get some answers, so if you dont want to read the thread dont click on it.

I don't just read threads - I try to help people when I can. Every board I have heard of, prohibits cross posting. You have crossed posted these 2 questions on every forum here and at MM's site.

Those of us that take the time to help are burdeoned with having to deal with your cross-posts. You are asking for full blown applications:

1. a file locking mechanism, and
2. a source code tracking mechanism

A single post with this question, implies that you are looking for some direction. Cross posting, as you have done, shows that you are just trying to "bang" this application out for your own profit (www.artemis.ae/page.asp?PSID=2&PageID=32).