Shared Database Access

Hi,
there are several possible ways to implement shared database editing.

Here is what I can recommend:

1. Add a field to your database table which will hold some unique value.
   
   It can be ReplicationID field in MS Access or Uniqueidentifier field in MS SQL.
   Your table structure can look like this:
   
   ID - int, primary key
   
   Name - varchar
   
   UniqueID - uniqueidentifier
   
2. You read this field value on the edit page ( don't have to display it though )
   
   and use it in WHERE clause. The same time you update this field with new value. Here is the syntax for MS SQL.
   

   Update <table> set name='...', UniqueID = newid()
   

   
   where  id = ... and UniqueID = <old UniqueID>

This will prevent second person from updating this record without rereading data.
It sounds like you need to generate code with ASPRunner and make some adjustments.
Sergey Kornilov