jasperjasper
Programmer
We have a process that runs at night which has a number of macros that build tables. The database is running up against the 1 gig limit. How can we do a scheduled job that can compact the database in the middle of the job.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to compact during a macro or in a scheduled job
- Thread starter jasperjasper
- Start date
- Status
Should be easy. Just schedule a Task to run:
"C:\Program Files\Microsoft Office\Office10\msaccess.exe (location of your executable)" "C:\Documents and Settings\24sjf2\My Documents\Access Development\QAPI\DCSS QAP dB_be.mdb (the name of your db" /compact
I'm not sure what you mean by 'in the middle of the job'
"C:\Program Files\Microsoft Office\Office10\msaccess.exe (location of your executable)" "C:\Documents and Settings\24sjf2\My Documents\Access Development\QAPI\DCSS QAP dB_be.mdb (the name of your db" /compact
I'm not sure what you mean by 'in the middle of the job'
SUnderwood
Programmer
Maybe you should consider migrating to MSDE.
Business and Data Analyst
Database & Web Applications
International Applications Development
VB,VBA,ASP,SQL,Java,Pascal,ADA,SSADM,UML
seanunderwood1@hotmail.com
Business and Data Analyst
Database & Web Applications
International Applications Development
VB,VBA,ASP,SQL,Java,Pascal,ADA,SSADM,UML
seanunderwood1@hotmail.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
