Compact & Repair = database locked ?

Steve Hebert

New member
Local time
Today, 07:48
Joined
Oct 7, 2008
Messages
6
I have my program broken out into two
data
forms

the data sits on my computer
the forms - all 3 computers have their own copy of forms

All of a sudden when I compact and repair the data on my computer - it locks it up so the others canot use it. It can be used on my computer tho. No ldb file exists.

If I make a copy - the copy is free for all to use - until I compact it.

BUT - If I compact the database from another computer thru the network - no problems - It is only when I compact it from the computer it is on.

I had this happen once before but somehow it corrected itself (Ya I know)

What am I missing?

Thanks in advance.

Steve
 
If you know what Access does with the database during the compacting process then your confusion ends, here it is step by step:

1. Closes the Database.
2. Creates a new database with the name db1.mdb. Copies all the objects, except the work files created within the parent database, into the new database db1.mdb.
3. Deletes the Original database.
4. Renames the new database (db1.mdb) to the parent database name.
5. Opens the compacted new copy.

Have a look at this Post:

http://www.msaccesstips.com/2008/06/repairing-compacting-database-with-vba.shtml
 
Last edited:
Appreciate the feedback...

I've tried that - in various forms.

I've even created a completely new - unreleated database on another computer.
Compact it on that computer and access it thru mine.

Move it to mine and all others still have access to it - until I compact it. - Once I compact any database on my computer it is locked up.
 
Is your installation of Access fully up to date with service packs and patches?
 
I just checked and all SPs and updates are updated.

Could this be a Windows setting or do you think it is definately an Access thing.
 
Most data base programs lock files to only one user so if the file is updated it can only be updated one at a time. If you had the software crash and exit incorrectly it may stay locked. If mult. people use the file then unless you are the first one on you will get the file locked indication. You can copy the database to a different file name and it should then you longer be locked.
az locksmith

 

Users who are viewing this thread

Back
Top Bottom