Hi All,

I've created a databae, back-end (tables) placed on a network-share, front installed on the machines from 5 different users,

Following problem occurs sometimes, in case a Poweruser wants to update the data (using an update qry) the systems does NOT update all records, following error will be shown, 'Microsoft Office Access can't update all the records in the update query,..........'

Does anyone have a solution how to unlock,... test for recordlocking,....


Thx

S.

Have you tried locking the table before running the query?

HTH RuralGuy (RG for short) acXP WinXP Pro