client server programming - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

client server programming

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

  • Dinu22Dinu22 Posts: 9Member
    : 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 :)

    Try locking the connection when it is being used by one user , lock and unlock the connection as per required
    :


Sign In or Register to comment.