Get sequence number uniquely for each user

[stars04]

I have developed a VB application which is gonna be used by multiple users. The problem is that everytime 2 or more users save a record at the same time, the users get the same sequence numbers. I have been unsuccesful in locking the record while one user is updating the record. With ADO recordset libraray, I have used Adopenkeyset and pessimistic lock , but haven't found a solution to this yet. Also the backend used here is Access, i wonder if these locks work in Access??? there must be some way!!
Please help as it is very very urgent.

 

[MoLaker]

It sounds like your problem occurs when creating new records, not when updating existing records. If that is the case, record locking will have little effect. Is the sequence number an Autonumber or is it created through some process when the user opts to open a new record?

 

[PHV]

Take a look at the FAQ area of this forum.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stars04]

Let me make it clear. i have table a called subjects which has different file subjects and each file subject has a counter which is incremented as and when a user selects a file subject from the table. what i need to do so, when the user A has selected the file subject say Policies with file counter no 10, and simultaneously when user B has selected the same file subject it should show 11.basically it should track if a user is updating this record and lock that record.

 

[hymn]

Have a look at
FAQ700-184

Hope this helps
Hymn