Tip of the moment is: SysCmd
SysCmd and the action
SysCmd 603, PathMdb, PathMde
Convert MDB to MDE SysCmd 602, PathMdb, PathMdb
compact DB
Dim accApp As Access.Application
Set accApp = New Access.Application
accApp.SysCmd 603, PathMdb, PathMde
accApp.SysCmd 602, PathMdb, PathMdb
Set accApp = Nothing SysCmd(605, 0)
convert DB to previous version
SysCmd(605, "C:\Database97.mdb") SysCmd(607,"C:\Project1.adp")
convert DB to ADP project SysCmd(608, i) 60 tips about Access programming where i=0...60 SysCmd(711)
Return put keyboard currently SysCmd(714) Returns TRUE, if any form, report,
macro or module is in design mode SysCmd(7) Detects the Access VERSION number SysCmd(715) Returns the Build number of MSACCESS.EXE file.
To see Access version and/or which Service
Pack is installed.
Access version Version and Build number Office 2000 9.0.0.2719
Office 2000 SR1 9.0.0.3822
Office XP 10.0.2627.1
Office XP SP1 10.0.3409.0
Office XP SP2 10.0.4302.0