'repairing a access database'

[FireBrick]

Hope this is the right forum.

I have a program that uses the access engine as it's database program.
It's keeps a log of contacts.

I have a little 3rd party utility to compact and to repair the file in case
the files are closed improperly.

the utility will work only if the program and the .mdb file are not open.

If I try to repair it while the file is open, I get the message:
"You attempted to open a database that is already opened
exclusively by user 'admin' on machine HS2.
Try again when the database is available."

Well I'm the only user and as far as I can tell have full admin privileges.

Is there a way around this.
And if there is...can I damage my database by compacting or repairing it
while it's open?

Please and thank you.

 

[TC]

No can do. There is no way to compact or repair a database that is
current open.

HTH,
TC

 

[FireBrick]

Thank you, that's what I thought

 

[Guest]

Firebrick

if your database is open you will have an extra file with the extension .ldb

What you need to do is copy the access database file with the extension .mdb
to another location. You can then run the microsoft compact utility called
jetcomp to repair and compact your access database. The copying of the
database to another directory removes your problem of the database thinking
it is open.
once you run the compact utility copy the fixed database back to its
location and you should be fine.

you dont have the problem of access permissions.

hope this helps

 

[TC]

Not so!

Copying an open database is not guaranteed to produce a working copy
file. The copy action will produce a file - but that file will not
necessarily open successfully with Microsoft Access.

HTH,
TC