Quote:
>How can you use the compact SendKeys %TDC to compact the
>current database when you have the allow full menu
>disabled in the startup? I do not want users to be able to
>have access to the stuff in the full menu, however can't
>use Sendkeys without the tools menu. HELP! I am a newbie
>and am running A97. Any info will be greatly appreciated!
You can't compact an open database anyhow, and certainly not a shared
database; and Sendkeys is as buggy as the Harvard Museum of
Comparative Zoology entomology collection.
I'd suggest having a shortcut running Access in command line mode
using the /Compact switch:
"C:\Program Files\Microsoft Office\Office\msaccess.exe" /Compact
"K:\somepath\yourdatabase.mdb"
in its action line. Just click the icon and it'll either compact or
complain that it requires exclusive access.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
Compact SendKeys