Hi All
I really hope someone can help here.
I have an access 2000 db as a backend for my asp.net application. There can be up to 10 concurrent users and each user deletes and appends his records in the tables based on his username. The tables are indexed using the username.
My problem is that sometimes I get the following error message.
Could not update, currently locked.
I'm presuming this happens when two users are deleting/appending records from the same table at the same time even though they are deleting different records (i.e. their own records based on their username)
I hope there is a saviour out there!
Thanks
Dave
I really hope someone can help here.
I have an access 2000 db as a backend for my asp.net application. There can be up to 10 concurrent users and each user deletes and appends his records in the tables based on his username. The tables are indexed using the username.
My problem is that sometimes I get the following error message.
Could not update, currently locked.
I'm presuming this happens when two users are deleting/appending records from the same table at the same time even though they are deleting different records (i.e. their own records based on their username)
I hope there is a saviour out there!
Thanks
Dave
