Compacting Access DB on-line

Results 1 to 2 of 2

Thread: Compacting Access DB on-line

  1. #1
    Richard Jurek Guest

    Default Compacting Access DB on-line

    Does anybody have an idea how to compact an Access database on a server. I wrote a VB app that works but I must have access to the Windows NT Server scheduler to make it work. My hosting service will not allow that.

  2. #2
    Join Date
    Dec 1969

    Default RE: Compacting Access DB on-line

    Try this<BR>&#060;%<BR>Set Engine = CreateObject("JRO.JetEngine")<BR>Engine.CompactDat abase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:inetpubwwwrootmydatabase.mdb", _<BR>"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:inetpubwwwrootmydatabase.mdb"<BR>%&#062;< BR>

Posting Permissions

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