Running a macro or executing a module from an ASP page

[Eli the Iceman]

Is there a way to run a macro within MS Access, or Module, from a web page?
I have a macro that runs a series of update make table and update queries and
would like to execute it from a web page. The DB feeds an ASP page with info
and when updates are made I would like to create the Table that feeds other
pages info.

Thanks

 

[Alex Dybenko]

Hi,
generally you can do this - if you give enough permissions to asp service
user - you can create access instance from asp page using
CreateObject("Access.Application"), open you database there and then run
whatever you need. But better way - is to run all your queries directly from
asp page using ADO

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com