JETCOMP.exe utility switch to path to database to compact

This question was originally posted on this list and then cross posted to the
wrong list. Since time has elapsed I'm posting again here with the answers
to my original questions which now have new questions to the answers. My new
questions are in all caps to set them off. BOB BARROWS MVP ANSWERED THIS
ORIGNALLY.
..
Janis wrote:
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.
THERE IS NO LINK TO A SEPARATE ACCESS 2003 JETCOMP.exe ON THAT PAGE. ON THAT LINK IT HAS ALL THE THE VERSIONS LISTED ABOVE EXCEPT ACCESS 2003 WHERE THE DOWNLOAD FOR THE UTILITY IS. THEN IT SEPARATES OUT ACCESS 2003 BELOW AS IF THERE WAS ANOTHER DOWNLOAD FOR ACCESS 2003 BUT IT DOESN'T GIVE THE LINK. I AM THINKING THERE WERE 2 UTILITIES AND NOW THEY ARE COMBINBED? OTHER THAN THAT I CAN'T FIND A DIFFERENT UTILITY FOR 2003.

The
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/library/d5fk67ky(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
it.
OKAY I TRIED THE COMMAND LINE AND READ ALL THE OPTIONS. I CAME UP WITH THIS
cmd c:\Program Files\Microsoft Office\JETCOMP.exe /S "c:\SwimClub\acsc_be"
.

Relevant Pages

  • RE: Event ID 447
    ... Please made a backup for Exchange database first. ... Please run the eseutil /mh command to see if the mailbox store is clean ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint Database falling over event 1000
    ... Microsoft Small Business Server Support ... > I Have Just run the SQL command from the command Line, ... > affected)1> exitDoes this say the database is Ok?If so why since we loaded ... > I/O operation has been aborted because ofeither a thread exit or an ...
    (microsoft.public.windows.server.sbs)
  • Re: Too many args when running a stored procedure
    ... Perhaps you have a duplicate definition of "AddAJob" in the master database schema. ... you don't show that you are associating the connection object with ... >> it with the command object. ... >>> @Rate money ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Please Urgent - Update Data Source Problem ???
    ... then there's nothing to submit to the database. ... values that are only assigned by the DB once the update command is executed. ... > the connection. ... > schedule, and they can update the existing schedule, add new schedule ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Problem with SQLServerCE
    ... all the operations done against the database work fine for some ... SqlCeTransaction transaction = null; ... connection = GetConnection; ... SqlCeCommand command = new SqlCeCommand("SELECT id from ...
    (microsoft.public.sqlserver.ce)