Gaining back space in Access tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a SQL Server application which deletes data in access tables and
transmits new data daily through DTS. Is there a way to prevent the need of
Compact And Repair programatically or do I have to have the user Compact And
Repair the database manually on a daily basis ?
 
One way to to this would be to use the Compact On Close option.
Tools, Options, General, 3rd check box on the lower left of the dialog.
 
Thank you.

Klatuu said:
One way to to this would be to use the Compact On Close option.
Tools, Options, General, 3rd check box on the lower left of the dialog.
Click to expand...
 
You must log in or register to reply here.

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

What are the steps to fix damaged MDF files in SQL Server? 0
Error When Attempting to Compact and Reapir 9
Help needed in linking to tables using Access 2007 1
Database locking with linked tables 1
Access Deleted Table after Compact and Repair Database (Access 2010) 0
Linked table problem 1
import in Access 2007 9
Compact and Repair Advice 14

Back
Top