CursorType and Locktype

[MUKESHY12390]

Hi Frnds,
I am creating oneUserFrom in Excel and my backend will be Ms Access.
multiple User will access this at same time for (update and Delete).
just I wanted what CursorType and Locktype I sould use.

 

[MUKESHY12390]

no doubt the information you all have given is useful.

....but where is my answer

there will be only one TABLE.....I hope this is enough.

 

[xenou]

In general use adOpenDynamic and adLockOptimistic or adLockPessimistic.

See here:
Database Cursors - Microsoft Access and ADO

and also:
http://www.functionx.com/vbaccess/Lesson26.htm

As you might guess, two users could open the same record at the same time with the optimistic locking, so if you have a likelihood that this will happen (multiple users who will be interested in the same data at the same time) then you would want to test that to see what happens and how to handle it, or consider using pessmistic locking instead. With pessimistic locking, the problem doesn't entirely go away - users might find it annoying if they are frequently locked out of records. So again, test and see what behavior you prefer. Depending on how users interact with the database, both might work equally well.

As noted previously, if the data is only for reading, you can use adOpenForwardOnly for faster performance.

It's been a while since I've dealt with this so take my answer with a grain of salt - but in general you can try one way and if there's problems try the other.

 

[MUKESHY12390]

this is what I was looking for ....thank you so much.