Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
running an Access Macro in ASP
- Thread starter thepp26
- Start date
AFAIK, ADO doesnt have the capability to do this. You'll need to resort to either DDE or COM Automation.
Set oAccess = CreateObject("Access.Application"
WITH oAcces
.OpenCurrentDatabase "C:\MyAccessDB.mdb"
.DoCmd.RunMacro "MyMacroName"
.CloseCurrentDatabase
.Quit
END WITH
Set MyAccessObject = NOTHING Jon Hawkins
Set oAccess = CreateObject("Access.Application"
WITH oAcces
.OpenCurrentDatabase "C:\MyAccessDB.mdb"
.DoCmd.RunMacro "MyMacroName"
.CloseCurrentDatabase
.Quit
END WITH
Set MyAccessObject = NOTHING Jon Hawkins
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question