Re: JETCOMP.exe utility switch to path to database to compact

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"JRough" <jlrough@xxxxxxxxx> wrote in message
news:acf0cfa6-e6c3-487a-80de-bda6ed9e09db@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 18, 8:04 pm, "Al Dunbar" <aland...@xxxxxxxxxxx> wrote:
"JRough" <jlro...@xxxxxxxxx> wrote in message

news:7da25723-d9ff-4bb1-843b-28fec2211357@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 16, 5:26 pm, "Al Dunbar" <aland...@xxxxxxxxxxx> wrote:



"JRough" <jlro...@xxxxxxxxx> wrote in message

news:4efc7bf9-f1af-423b-aa7b-c9424456ef60@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 14, 8:11 pm, JRough <jlro...@xxxxxxxxx> wrote:

On May 13, 9:07 pm, "Al Dunbar" <aland...@xxxxxxxxxxx> wrote:

"JRough" <jlro...@xxxxxxxxx> wrote in message

news:baa75d5d-2324-413d-84ab-0ccd8b94ea26@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 12, 9:37 pm, "Al Dunbar" <aland...@xxxxxxxxxxx> wrote:

"Janis" <Ja...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

news:8CE13510-E01A-4BAD-B10E-5B6808118214@xxxxxxxxxxxxxxxx

I just noticed your name is Al so I guess the command is
cmd /c "c:\Program Files\Microsoft Office\JETCOMP.exe" /s
"c:\SwimClub\acsc_be"

and does that work for you?

/Al

I run this cmd /c "c:\Program Files\Microsoft Office\JETCOMP.exe" /s
"c:\SwimClub\acsc_be"

=================

I'll take that as a "yes, this works".

/Al

Al, I'm sorry it doesn't work. I don't know what happened to the
full message. I ran the command line script many times. I get an
error message something about can't find the internal program. The
DOS window scrolls too fast to read it very well. But you get the
gist. I also went back to the Jetcomp.exe utility. When you run it
manually you have to give the path to the database and the name of the
database you want to compact to and when you close it, it is not saved
so it has to be in the command line script. I think what is missing
in the command you gave me is the name to output the compacted file
to. Where would I add that to this script so I can try it again?

thanks and sorry about that, JR

I'm only doing run from the command line to run the utility. I gave
that to you exactly. Can't you run that command line script from the
command line by hitting "enter"? It does run in the DOS window. I
figure it should work first before I automate it in VBScript for the
customer. Are you saying I have to put that compacted output filename
path to the db in VBscript?

===============

When I enter that command exactly as shown, the following error message
appears:

'c:\Program' is not recognized as an internal or external command,
operable program or batch file.

I assumed from this that CMD required some sort of adjustment to the
double
quoting because of the whitespace in the path. I tried a similar command
using a copy of notepad located in a path having blanks and there was no
problem. Then I noticed that the office folder did not contain an
executable
named jetcomp.exe. I deleted my test copy of notepad.exe, and the
command
that had previously worked now failed because the executable no longer
existed. But the error essage was:

'C:\Documents' is not recognized as an internal or external command,
operable program or batch file.

whereas one would normally assume that it should give the full name of
the
actual file that was missing. That is indeed the behaviour when the
command
is issued without the "CMD /C".

I conclude from this that even though CMD is capable of interpreting the
pathname provided, the error reporting routine used in that context is
not
able to do so. I also conclude that your computer may be missing the
jetcomp.exe file, or that you have its path incorrect.

I'd suggest you see if the command works without the "CMD /C". If so,
I'm
stumped; if not, what is the error message?

Why are you using CMD /C? If you eventually get your script to work, you
will be using the .run method, so the only benefit of using CMD would be
to
redirect the output with ">". Regardless, the simplest solution might be
to
write the command you want to execute into a batch file and run that
from
your script.

/Al

Sorry,
I do have JetCOmp.exe. I installed it in here so I could remember
where I put it: C:\Program Files\Microsoft Office

===================

No need to apologize. But you could perhaps have done what I suggested you
do, namely:

"I'd suggest you see if the command works without the "CMD /C". If so,
I'm stumped; if not, what is the error message?"

In addition to that, if you could provide the exact text of the error
message you get when using CMD /C, that would be helpful as well.

Until I have that info, anything else I might say could only be a guess.

/Al

I don't know a whole lot about DOS. I just want to run this command
to run JETCOMP.exe utility to compact an Access database. I'm getting
a weird error message and wonder if something is wrong with my DOS set
up?

Here is the command:
CMD /C "c:\Program Files\Microsoft Office\JETCOMP.exe" /s "c:\SwimClub
\acsc_be"

I get the error message 'c\Program' is not recognized as an internal
or external command, operable program or batch file"


====>
As per my previous reply, this would seem to indicate that there was no such
file as jetcomp.exe located in the indicated folder.
<====

If I run it without the CMD /c for example "c:\Program Fiels\Microsoft
Office\JETCOMP.exe" /s "c:\SwimClub\acsc_be" then I don't get any
messages at all. All I get is the DOS prompt back alone for example
like this:
C:\Documents and Settings\janis>


====>
that tells us nothing. did the database get compacted or did it not?
<====

So I just need to see if one of these commands will work and compact
the database then I can put it either in a batch file or a vbscript
file whichever is easier since I don't know how to do either one but I
think I prefer the vbscript one since I can put the vbscript icon on
the users desktop and the user can run it from there.
thanks,

=====
Geez, you can put a batch file on the users desktop too - so what is your
real reason for wanting to do this with vbscript?

OK, so my best guess is that the jetcomp.exe does not exist where you think
it does. Run this batch script on your system:

@echo off
>%temp%\jetcomp.txt dir "c:\Program Files\Microsoft Office\*.*

and post back here the content of the jetcomp.txt file you will find in your
TEMP directory.

/Al


.

Relevant Pages

  • Re: log off command
    ... I simply execute the batch file and let them play... ... If it's by the hour you don't need a script. ... You can logoff a sessionname or a session ID in each case you have to ... Is it possible to issue the command from user1's logon to logoff ...
    (microsoft.public.windowsxp.basics)
  • Re: log off command
    ... I simply execute the batch file and let them play... ... If it's by the hour you don't need a script. ... You can logoff a sessionname or a session ID in each case you have to ... Is it possible to issue the command from user1's logon to logoff ...
    (microsoft.public.windowsxp.basics)
  • Re: Command or setting to force monitor on?
    ... Keystrokes vbs script? ... But the same symptoms as without cscript, monitor not waking up, when I ... I set up a batch file containing the commands to first start IE, ... could move to the keystrokes command. ...
    (microsoft.public.windowsxp.general)
  • Re: Scheduled script problem
    ... A vbs script that sets up a command to run a batch file, calls EXEC on the ... until the scheduler stops the script after the maximum allowed time to run. ...
    (microsoft.public.windows.server.scripting)
  • Re: Scheduled script problem
    ... A vbs script that sets up a command to run a batch file, calls EXEC on the ... until the scheduler stops the script after the maximum allowed time to run. ...
    (microsoft.public.windows.server.scripting)