Hmm, you chose the wrong Access group to crosspost this to. Your question
has nothing to do with Access macros. You should have chosen one of the VBA
groups if you wanted their input.
> I don't think this utility is working. I downloaded the compact
> utility. I created a new empty database. In the utility I selected
> the soruce backend database. I selected the compact to database as
> the new blank database. It got an error when I ran it and no
> explanation as to what was wrong. This database was a Access 2000
> but it was upgraded to Access 2003. Could that be the reason? .
Probably. There was a link in the article I posted to this article: http://support.microsoft.com/kb/295334/EN-US/
which does apply to Access 2003.
> other question, isn't this utility for a tech support person? I
> don't know if it will stay set up for the from and to sources for a
> technically challenged user? I may need to stick with the script.
This utility can be run from the command line, so you can use WshShell .run
to run it. See http://msdn.microsoft.com/en-us/libr...ky(VS.85).aspx
When you have the correct version of the utility downloaded, open a command
window (enter "cmd" into the Start > Run dialog) and enter
p:\ath\to\jetcomp.exe /? to see the command line options. Experiment with
creating the proper command line to run jetcomp to compact your database,
and when you have it, use the Run method in your vbscript code to execute
PS. It is always recommended to back up your database before compacting it.
You can use the FileSystemObject to copy your database file - look it up in
that link to the documentation I provided in the next to last paragraph
above. If you would like a downloadable .chm file containing the scripting
documentation, go here: http://tinyurl.com/7rk6