MS Access Compaction

Results 1 to 2 of 2

Thread: MS Access Compaction

  1. #1
    Joe Rutledge Guest

    Default MS Access Compaction

    Anyone know how to compact an MSAccess DB using ASP and vbscript? I don&#039t have, and do not intend to install, Access on my server. I&#039m using an Access 2000 db setup using the most recent ODBC drivers. Its set up as a system dsn...<BR><BR>email:-

  2. #2
    Join Date
    Dec 1969

    Default RE: MS Access Compaction

    This should work (though I&#039ve never tried it)...<BR><BR>dim je<BR>Set je = Server.CreateObject("JRO.JetEngine")<BR>&#039shoul d probably check to make sure the new file doesn&#039t exist<BR>&#039and delete it if it does<BR>je.CompactDatabase "Data Source=C:olddb.mdb;", _<BR>"Data Source=C:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts