compact database in CL

6

'69 Camaro

Hi, Jim.

Yes. Use syntax such as the following (watch out for word wrap):

"<Full path to MSAccess.EXE>" "<Full path to source DB file>" /compact
"<Full path to target DB file>"

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
6

'69 Camaro

On second thought, that suggested syntax is a little confusing. Try this
syntax instead (watch out for word wrap):

"<Full path to MSAccess.EXE>\MSAccess.EXE" "<Full path to source
DB>\Source.MDB" /compact "<Full path to target DB>\Target.MDB"

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
Top