Gaining back space in Access tables

R

rmcompute

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 ?
 
K

Klatuu

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.
 
R

rmcompute

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

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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
"Compile error in table level validation expression " after format 0
Compact and Repair Advice 14
Linked table problem 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Help needed in linking to tables using Access 2007 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Refreshing Data Daily From a Linked Excel Spreadsheet 2

Top