hi,
I am working on project where Database is placed in server.Database is in Access.i am using adodb.Now my requirement is,multiple user on different machine can add different records to same table.
i am using code like
recordset.source=query
recordset.CursorLocation = adUseClient
recordset.CursorType = adOpenDynamic
recordset.locktype=adLockOptimistic
recordset.ActiveConnection = Conn
recordset.Open
now what changes should i make so my purpose can solved.Please help and guide me urgently.
Ganesh
Comments
: I am working on project where Database is placed in server.Database is in Access.i am using adodb.Now my requirement is,multiple user on different machine can add different records to same table.
: i am using code like
:
: recordset.source=query
: recordset.CursorLocation = adUseClient
: recordset.CursorType = adOpenDynamic
: recordset.locktype=adLockOptimistic
: recordset.ActiveConnection = Conn
: recordset.Open
:
: now what changes should i make so my purpose can solved.Please help and guide me urgently.
: Ganesh
Try locking the connection when it is being used by one user , lock and unlock the connection as per required
: