alekm said:
Hi, I want to schedule compacting access database. How do I execute
compact
and repair from command prompt?
Thanx in advance.
alek_mil
From the help file:
1.. Open the folder where Microsoft Access is installed (located by
default in C:\Program Files\Microsoft Office\Office11).
2.. Right-click the Microsoft Access program icon, and then click Create
Shortcut.
3.. Right-click the shortcut icon just created, click Properties, and then
click the Shortcut tab.
4.. Click to the right of the Microsoft Access startup command in the
Target box, and then type the desired command-line options.
For example, the following command line starts Microsoft Access and opens
the Northwind sample database for exclusive access.
"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Program
Files\Microsoft Office\Office11\Samples\Northwind.mdb" /excl
Replace the path to Northwind.mdb with the path to your mdb, and replace
/excl with /compact
