Vista - JETCOMP.exe utility switch to path to database to compact

05-11-2009

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:

Quote:

> 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.

Quote:

>> 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.

Quote:

> 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/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
it.

Quote:

>> 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"

05-11-2009

Janis wrote:

Quote:

>> 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.

Quote:

>>> THERE IS NO LINK TO A SEPARATE ACCESS 2003 JETCOMP.exe ON THAT
>>> PAGE.

Oh come on - scroll down on that page and see this:
APPLIES TO
a.. Microsoft Office Access 2003<==========
b.. Microsoft Access 2002 Standard Edition
c.. Microsoft Office XP Developer Edition
I'm not sure if your problem is resolved or not.

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

05-11-2009

I'm sorry, I got the database to compact using the JetComp.exe utility.

"Bob Barrows" wrote:

Quote:

> Janis wrote:

Quote:

> >> 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.

Quote:

> >>> THERE IS NO LINK TO A SEPARATE ACCESS 2003 JETCOMP.exe ON THAT
> >>> PAGE.

>
> Oh come on - scroll down on that page and see this:
> APPLIES TO
> a.. Microsoft Office Access 2003<==========
> b.. Microsoft Access 2002 Standard Edition
> c.. Microsoft Office XP Developer Edition
> I'm not sure if your problem is resolved or not.
>
> --
> Microsoft MVP - ASP/ASP.NET - 2004-2007
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>

05-11-2009	#1 (permalink)
Janis n/a posts	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: Quote: > 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. Quote: Quote: >> 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. Quote: > 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/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 it. Quote: Quote: >> 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"
My System Specs

05-11-2009	#2 (permalink)
Bob Barrows n/a posts	Re: JETCOMP.exe utility switch to path to database to compact Janis wrote: Quote: Quote: >> 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. Quote: Quote: >>> THERE IS NO LINK TO A SEPARATE ACCESS 2003 JETCOMP.exe ON THAT >>> PAGE. Oh come on - scroll down on that page and see this: APPLIES TO a.. Microsoft Office Access 2003<========== b.. Microsoft Access 2002 Standard Edition c.. Microsoft Office XP Developer Edition I'm not sure if your problem is resolved or not. -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
My System Specs

05-11-2009	#3 (permalink)
Janis n/a posts	Re: JETCOMP.exe utility switch to path to database to compact I'm sorry, I got the database to compact using the JetComp.exe utility. "Bob Barrows" wrote: Quote: > Janis wrote: Quote: Quote: > >> 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. Quote: > >>> THERE IS NO LINK TO A SEPARATE ACCESS 2003 JETCOMP.exe ON THAT > >>> PAGE. > > Oh come on - scroll down on that page and see this: > APPLIES TO > a.. Microsoft Office Access 2003<========== > b.. Microsoft Access 2002 Standard Edition > c.. Microsoft Office XP Developer Edition > I'm not sure if your problem is resolved or not. > > -- > Microsoft MVP - ASP/ASP.NET - 2004-2007 > Please reply to the newsgroup. This email account is my spam trap so I > don't check it very often. If you must reply off-line, then remove the > "NO SPAM" > > >
My System Specs

Similar Threads
Thread	Forum
automate running JETCOMP.exe utility to compact an Access db	VB Script
vb script to compact Access database, how to add login & pw	VB Script
Compact Database on Shutdown	Live Mail
WMUtil -- New Free utility to compact and repair the Windows Mail database in Windows Vista	Vista mail
Fail to compact the database on every Mail exit	Vista mail