DB Compacting (97)

Topic

New Reply

All,

We are trying to compact the db that our code is running in. This is easy once you move to 2000 onwards. But in our friendly 97 version we can not seem to come up with a solution.

The DBEngine command requires a source and destination, but this can not work as we have the db open, running the code.
Th Docmd. RunCommand accmdcompact optioin opens a file dialog to search for the file you wish to compact.

Please help. This is needed as we are using temp tables and they tend to blow the db size out if you don’t compact.

Reply | Quote

Replies

Hi Cindy…

I’ll be waiting anxiously for one of the Woody’s Gurus to answer this question… I have been working with Access 97 for more than a few years now and I remember back when I started using it trying and trying to compact programmatically… I couldn’t get anything to work… I asked here too, I’m sure of it… It’ll be great when we upgrade to 2000 or 2002…

Wish I could help you… Good luck!

Reply | Quote

The Access Web has an two different solutions you can use:
Access 97 Compactor Addin works entirely within Acccess.
VB5 Compact Database utility (Access 97) is a stand-alone application.

Reply | Quote

The Access Web has an two different solutions you can use:
Access 97 Compactor Addin works entirely within Acccess.
VB5 Compact Database utility (Access 97) is a stand-alone application.

Reply | Quote

Essentially, you can’t. The code functionality doesn’t extend to the currently open database, only to other databases, which includes the linked back end. If you want to do this from within the database, you’ll have to use a tool like those Hans posted links for. And for your information, you still can’t do it from code in the later versions from within the current database, although you can do it from the menubar with the database open in 97 forward.

Reply | Quote

Essentially, you can’t. The code functionality doesn’t extend to the currently open database, only to other databases, which includes the linked back end. If you want to do this from within the database, you’ll have to use a tool like those Hans posted links for. And for your information, you still can’t do it from code in the later versions from within the current database, although you can do it from the menubar with the database open in 97 forward.

Reply | Quote