How Can I Run an Access Macro from an ASP page?

[cnulman]

I've exported the Access 97 database using it's Web Wizard to convert it to ASP. Unfortunately, in the conversion the button to run the main macro was not converted. This macro primarily runs approximately 150 action queries.

I would love your help to resolve a way to run the macro from an ASP page.

Cliff Nulman
Taunton, MA
cnulman@alslights.com

 

[palbano]

Cliff,

This sounds more like an Access question. Have you tried any of the MS Access forum here at Tek-Tips?

-pete

 

[Pandyon]

I've asked a similar question a few times on this forum and the access forum with no luck. My own research says it can't be done.

What you CAN do is...

Convert the macro to a visual basic module. Convert the module to an ActiveX.dll component.
Write your asp to call the component.

That's the only way I've found to use Access Code in ASP.
If anyone knows another way...please, oh please, tell us how.

Pandyon