Automate compaction

[Charles L. Phillips]

Hello,
I have a MS-Access 97/2003 database, on a Windows XP system acting as a
server for the database.
I need to compact this database every Friday, at 9:30 p.m.
My question, "can this be done automatically & how...
Can someone point me to some examples???


Thank you,

 

[Tom Wickerath]

Hi Charles,

If you want a solution that is ready-to-go, then try Total Access Agent from
FMS:
http://www.fmsinc.com/products/Agent/index.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hello,
I have a MS-Access 97/2003 database, on a Windows XP system acting as a
server for the database.
I need to compact this database every Friday, at 9:30 p.m.
My question, "can this be done automatically & how...
Can someone point me to some examples???


Thank you,

 

[Arvin Meyer [MVP]]

You can use Total Access Agent:

http://www.fmsinc.com/products/Agent/index.html

You can create a task using the Windows scheduler, and some code in another
Access database:

DBEngine.CompactDatabase "C:\PathTo\TheOld.mdb", "C:\PathTo\TheNew.mdb"

'Delete the Old Database
Kill "C:\PathTo\TheOld.mdb"

'Name the New DB to the Old DB name
Name "C:\PathTo\TheNew.mdb" As "C:\PathTo\TheOld.mdb"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Ron Hinds]

You could also use JetComp from Task Scheduler:

http://support.microsoft.com/default.aspx?scid=kb;en-us;273956

You can use Total Access Agent:

http://www.fmsinc.com/products/Agent/index.html

You can create a task using the Windows scheduler, and some code in another
Access database:

DBEngine.CompactDatabase "C:\PathTo\TheOld.mdb", "C:\PathTo\TheNew.mdb"

'Delete the Old Database
Kill "C:\PathTo\TheOld.mdb"

'Name the New DB to the Old DB name
Name "C:\PathTo\TheNew.mdb" As "C:\PathTo\TheOld.mdb"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access