compacting

D

Denny Marshall

I'm using a DTS package to delete then insert records into
an Access database from SQL Server. This causes the
Access database to "bloat" in size. How can I have the
DTS package automatically compact the Access database
after the delete/insert sequence?
 

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
Gaining back space in Access tables 4
"Compile error in table level validation expression " after format 0
Error-17099 SMTP Relay Error Problem Entourage 2004 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Error When Attempting to Compact and Reapir 9
Linked spreadsheet problem 2

Top