Hello,

I have many applications (DOTNET. Connected using OleDB) that all
write data to the same table in a Access database file.

But sometimes I get the error "Could not update; currently
locked" ??!!!!!

How can this be possible???? I only do inserts into the table...
Does Access lock the entire table when inserting a record ????

I searched a lot on google groups but didn't find any user having the
same problem...

Please help me...

Microsoft Access actually uses page locking, in other words it locks groups
of records at a time.

Another reason could be that somebody has opened the table in exclusive
mode, or evened opened the datafile directly. In exclusive mode, only one
computer can modify data. You could fix this by creating an 'Autoexec'
Macro in the data file to exit the database as soon as someone opens it.
Of course, you'd have to hold the Left Shift-Key if you ever wanted to open
the data file and bypass the Autoexec Macro from executing.


Dom

<palm.kevin (AT) gmail (DOT) com> wrote