Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2632
  • Last Modified:

Compact and repair batch file

How would I go about creating a batch file that could compact (and repair) my database?
Hopefully this is easy. (i just could not find any information about how I could do this from a command prompt (batch file))

Thanks.
0
ThaSmartUno
Asked:
ThaSmartUno
  • 2
1 Solution
 
shanesuebsahakarnCommented:
This command line should do it:

"<path to msaccess.exe>" "<path to your mdb>" /compact
0
 
ThaSmartUnoAuthor Commented:
Thank you
0
 
Simon BallCommented:
How does he get there so fast?!?!?!
0
 
ThaSmartUnoAuthor Commented:
I don't know, but I could have sworn I had accepted his answer earlier too
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now