Access application - can not write due to locked table.

[mrbg07546]

Hi -

I have a distributed MS access application (front end and back end infrastructure) which occasionally throws a error. and its because it runs a Delete query and table is locked.

Cant work out why this is happening - any ideas.?

Kind regards

Manpreet Ruprai

 

[Ranman256]

deleting can lock tables. If this is a shared table, it could happen.
If this IS a multiuser app, and you don't want to lock out, You could MARK records for
deleting, then actually delete them after hrs downtime.

Normally you don't delete records in a mutli user database. Records are forever.