why does Access lock a database after it compacts it?

[markartist]

why does Access lock a database after it compacts it?

 

[KenReay]

Hi

Explain what you mean by 'lock' as far as I know it does not lock it ?

Regards

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

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

UK

 

[rokerij]

Actually, if I am right, the end user is getting a 'Ready' in the bottom left hand corner of the screen, but probably still has the hour glass as the cursor. Even though Access reads that it is ready, it is still working in the background. If a user goes and tries to open up the database, it will be locked still as finishes up it's process. Patients usually pays off here, and wait until you are able to see the regular cursor, and then open the database to check the integrity.

S.C. Albertin
Database Administrator/Newbie Tech
United Way

Help me to find my way, so that I may help others find theirs...

 

[markartist]

What happened was that I opened Access and then the database and then selected "Compact and Repair". The status bar completed and the cursor changed so I closed Access and then attempted to access the database and it told me it could not find the specific db or that it was locked.

What I did after that was to rename it and then name it back and then it would allow me to access it. My question is...why did it lock it when I compacted it?

 

[cheerio]

Is this on a network or on a local hard drive?

 

[markartist]

Currently this is on a local drive

 

[rokerij]

Was the ldb completely gone from the file when you began your compact and repair? I have not known Access to lock from a compact and repair utility.

S.C. Albertin
Database Administrator/Newbie Tech
United Way

Help me to find my way, so that I may help others find theirs...

 

[markartist]

Yes, the other one I tested was not even in use