Compact db on server without Access installed

[SusanV]

I would like to schedule compaction of my database (Access 2000) front and
backends prior to backing them up. However, the server (NT4) doesn't have
Access installed. I have read that it's a bad idea to compact/repair over
the network, so I'd really like to run this on the server, and the jetComp
utility doesn't seem to have any commandline capability.

Does anyone know of a utility that can compact/repair an Access db via
commandline without Access being installed?

TIA,

SusanV

 

[Rick Brandt]

I would like to schedule compaction of my database (Access 2000)
front and backends prior to backing them up. However, the server
(NT4) doesn't have Access installed. I have read that it's a bad idea
to compact/repair over the network, so I'd really like to run this on
the server, and the jetComp utility doesn't seem to have any
commandline capability.

Does anyone know of a utility that can compact/repair an Access db via
commandline without Access being installed?

You could use a scheduled Access file to...

Copy file to local disk
Rename file on server
Compact local copy
Copy file back to server
Delete renamed file if previous steps are successful

An alternative would be to include the Date in the file name of the renamed
file and NOT delete them. Then you have a dated backup copy of the back end
at the same time.

The commands you would use...

FileCopy
Name
dbEngine.CompactDatabase
Kill

 

[SusanV]

Thanks Rick for replying.

I keep multiple backups now using copy to another server (easier recovery if
that one goes down) in additional to backing up to tape (for archive
purposes), but since I split the db I've noticed quite a bit of bloat in the
backend due to temp tables being cleared and re-populated. I guess I could
run the compact from my machine at a prior time to the server running it's
backups, but i was hoping i could simply add a line to my backup.cmd file
prior to the line starting the backup to tape each night - one less thing to
have to check each morning.

Not a bad idea though - I could kick off a scheduled compact on my
workstation at a different time than the backup runs. Even if the compact
task doesn't always run because my workstation is shut down at least the db
would be compacted most nights.

Thanks again!

SusanV

 

[Van T. Dinh]

JetComp does have command-line capability.

=========
---------------------------
Jetcomp 4.0
---------------------------
Usage: JetComp
-src:{database name}
-dest:{database name}
-y{system database location}
-u{user name} (default=admin)
-p{user password}
-w{database password}
-x Encrypt Destination Database
-t Use Database Locale when copying data for text columns
-v4 Destination db is 4.x format (default)
-v3 Destination db is 3.x format
-L0 Db locale - None Use current language (default)
-L1 Db locale - English, German, French, and Portuguese
-L2 Db locale - Italian, and Modern Spanish
-L3 Db locale - Arabic
-L4 Db locale - Simplified Chinese
-L5 Db locale - Traditional Chinese
-L6 Db locale - Russian
-L7 Db locale - Czech
-L8 Db locale - Dutch
-L9 Db locale - Greek
-L10 Db locale - Hebrew
-L11 Db locale - Hungarian
-L12 Db locale - Icelandic
-L13 Db locale - Japanese
-L14 Db locale - Korean
-L15 Db locale - Norwegian and Danish
-L16 Db locale - Polish
-L17 Db locale - Slovenian
-L18 Db locale - Traditional Spanish
-L19 Db locale - Swedish and Finnish
-L20 Db locale - Thai
-L21 Db locale - Turkish
If no options are passed, GUI front end will start.
========

 

[SusanV]

Thank you Van - I couldn't find this anywhere!

Susan

 

[Van T. Dinh]

I was experimenting with it and tried:

jetcomp.exe /?

and voila, the MsgBox pops up with what I needed.

--
HTH
Van T. Dinh
MVP (Access)

 

[SusanV]

Doh! Silly me - never thought to try that!

Thanks again Van

;-)