compact database in CL

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
Can I compact database through the command line?
Thanks,
Jim.
 
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!)
 
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!)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compact and Repair Using Scheduled Tasks 2
Compact Database 3
Easy way to compact an Access 2003 database 1
Compacting Access database 2
Access 2007 compact database 1
Clarity needed re: compacting a database 11
Compact and Repair Advice 14
Compact DB on close 2

Back
Top