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.

The problem is the stateless nature of the web.

I would recommend using some kind of timestamp column to show when a database record is checked in and checked out.
Then use this timestamp to warn the second user that the item is being
edited what 'would you like to do?' And if the first user goes to save a
record that has been checked out by a second user ask, 'this record was
checked out by so and so, what would you like to do'? You can use a
timeout value to reset checkouts to account for lost sessions.

what if the user browse to another web page/site; system hang; quit IE? how to release the timestamp?