couldn't use the file already in use

[jonney]

Hi there

I have an access 97 database with a problem. It will not allow me to Compact or repair, coming up withthe above error message. The ldb file closes so it looks as if it is behaving except for the above issue. If I move the database to another folder it works. Other databases i the same folder work perfectly well. If I copy the database to my c drive it compacts and I can overwrite the offending database but it will not allow any compacting from this folder (on a network).

Any ideas?

Jonney

 

[KenReay]

Hi

"The ldb file closes", the .ldb file should be deleted when last user exist the db. Are you sure you ahve delete permissions full create, update, delete permissions in the folder?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[jonney]

Yes, my mistake. I meant the ldb file is deleted and the permissions for the folder seem fine as user can compact other dbs in the same folder. In fact this is a recent issue and until recently the file could be compacted. Any thoughts?

Jonney