Does anyone know how to crun the compact/repair database utility from an ASP page to reduce a databases file size? Everything I have is being hosted on a server that I am unable to install any new files on, and because of the size and activity it is a pain to actually make a copy, manually compact the db's, then re-upload them. I am looking for a way to write an asp page that can do it for me upon calling the page - or even a scheduled task via batch file.

Any ideas?

You can do that using the command line parameters of MSACCESS.exe. Create a batch file and schedule it as a task passing the MDB as a parameter to it. Batch file should contain code similar to the one given below. Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Awesome - Found an Excellent Way of Doing It In ASP In Case Others Were Wondering -- Code posted below.
------------------------------------------------------------------
  oldFile = Server.MapPath("../database/YourDB.mdb")
  newFile = Server.MapPath("../database/bak.mdb")

  strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& oldFile
  strConnBak = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & newFile

  Set objJRO = Server.CreateObject("JRO.JetEngine")
   objJRO.CompactDatabase strConn, strConnBak
  Set objJRO = Nothing


  Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
  If objFSO.FileExists(newFile) And objFSO.FileExists(oldFile) Then
   objFSO.DeleteFile(oldFile)
   objFSO.MoveFile newFile, oldFile
   Response.Write "Compact and Repair was successful."
  Else
   Response.Write "Compact and Repair failed."
  End If

  Set objFSO = Nothing

Great! Nice to know on that.

Cheers!

_________________________
- Vijay G
Strive for Perfection