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.
 
Back
Top