Compact and Repair without opening Database

W

W. Ray Lambert

Does anyone know the code to compact and repair a database
without opening it? I have a replicated database where
more than 100 copies are spread ove 5 states. all are
setup to compact on close, however 20 are not opened on a
regular bases since they are the full replicas most of the
partials are made from. I need to find a way to run
compact and repair much like replication manager runs
synchronization. Any ideas?

Thanks
Ray
 
R

Rick B

If you have Access open, but no database, then you can select the Compact
and Repair option from the menu. It will pop up a dialog box and allow you
to find the dataabse you wish to compact/repair.

If the ones you are looking for are rarely opened,though, it seems they
would not need to be compacted or repaired.

Rick B


Does anyone know the code to compact and repair a database
without opening it? I have a replicated database where
more than 100 copies are spread ove 5 states. all are
setup to compact on close, however 20 are not opened on a
regular bases since they are the full replicas most of the
partials are made from. I need to find a way to run
compact and repair much like replication manager runs
synchronization. Any ideas?

Thanks
Ray
 
R

Ray Lambert

Thanks. Wish that was the case, these databases are
synchronized every 4 hours so they are constantly in use
and synchronization does not compact and repair. So they
tend to double in size about every 2-4 days depending on
the user inspection cycle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top