jetcomp.exe utility parameteres

[JRough]

I need to automate running JETCOMP.exe utility to compact an Access
2003 database backend in VBScript but first I am trying to get it to
run from the command line. I have what I think is the CMD line
sequence. It has a password so I have the -u & -p parameters?
Something is keeping it from executing and I think it could be it
can't open the database. I don't think it is that it can't write the
database because it should be able to write something. JEtcomp works
when I run it from the utility. There is also a -w{database
password}. I don't know why there would be 3 passwords? I do have
the administrative password.
tnx,

"C:\Downloads|JetCOMP.exe" "-src:C:\Jetcomp\Bad.mdb" -uMyUser -
pMyPassword "-dest:C:\Jetcomp\Good.mdb"

 

[Tom van Stiphout]

On Tue, 26 May 2009 18:08:57 -0700 (PDT), JRough <[email protected]>
wrote:

There is a difference between Workgroup Security which requires a
username and password, and Database Password, which requires only a
password. If you are doing the former, you also likely need to
identify the path to the workgroup file (*.mdw).

-Tom.
Microsoft Access MVP

 

[david]

You don't need the JETCOMP gui.

In VBScript you can use the DAO dbEngine object directly:

set dbe = createobject("dao.dbengine.40")

dbe.SystemDB = "system.mdb"
dbe.DefaultUser = "fred"
dbe.DefaultPassword = "pwd"
dbe.CompactDatabase
"c:from.mdb","c:\to.mdb",";LANGID=0x0409;CP=1252;COUNTRY=0"

(david)