triggering a macro from a web form?

A

_adrian

I use VBScript/ASP in most of my web sites, and need to find out if I can
trigger an Access2000 macro from a button on a webform.. any thoughts?
 
N

Norman Yuan

Where the Access file (*.mdb/*mde) is located? Server side or client side?
Since macro runs inside Access application, you need to launch Access
application first. You can use COM Automation to run Access application and
have Access application to execute said macro(s). Theoretically, you can
automate Access on either server or client side, but it is definitely not
recommeded to automate Access on server side. If the macro is to process
data in that *.mdb file, you can use ADO to do the same thing, to avoid
Access automation and you do not need Access installed.

Access macro runs inside Access application. That means you need
 
A

_adrian

Thanks Norman.. yes, an ADO process would probably be a best choice... know
of any sources for suggested steps for building such?
 
Top