Compact database programmatically

[easycode]

I need to compact a database programmatically, i have checked all the faqs, none help.

I need the new compacted file to overwrite the no compacted file when i use the next instruction:

DBEngine.CompactDatabase "C:\DB\mydb.mdb", "C:\DB\mydb.mdb"

i get this error:

"You attempted to open a database that is already opened exclusively by user 'Admin' on machine 'FL50144'. Try again when the database is available.
and i heard that is because when access open a database it automatically creates an ldb security file, but this file can not be deleted.

Can anyone advice?

Thanks

 

[Zion7]

possibly this,
Docmd.RunCommand acCmdCompactDatabase

 

[PHV]

Have a look here:

http://www.mvps.org/access/general/gen0041.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[easycode]

I tried both suggestions and i am getting this error message:

"You can't compact the open database while running a macro or Visual Basic code.

looks like it's not possible to compact a database programatically because of the ldb file.

 

[easycode]

i just opened the database in an exclusive mode where there isn't a ldb file and i am still getting the same error message, so the error is not based on the ldb file but i think it just can't be done programatically!

 

[Zion7]

Sorry MS2000, I never tried it until now, just assumed.
Maybe it's only functional for remote connections?

 

[Seabz420]

This worked for me. thread705-1102193

 

[PHV]

Seabz420, the thread you mentioned use the same code as the link I posted.

 

[sophia03]

Run the code that you have from a different database. Don't run it within tha database tha you are trying to compact.