Can I convert a MS Access macro to VB and run it from an ASP page?

Been away from ASP for way too long and just getting back in for a
project.

Using IIS and Access 2003 on the server. I can set the server to
automatically download a text file report from a remote unix server,
and i've linked this file as a table in access. It can do this
periodically and then run an access macro that creates a table that my
client can use via a web application.

But sometimes we may need the client to force an update. If I
converted the macro to VB, could this be initiated by an ASP page?

Thanks.
"Forget it Jake.....it's Chinatown"

RE: Can I convert a MS Access macro to VB and run it from an ASP page?

The short answer: probably. It all depends on what your macro in Access
does. Most of the functionality, except stuff that is Access-specific, can
be duplicated in VBScript, the language that ASP uses. Then, you can allow
the user to invoke that script via a link or button on your web site.

HTH
John Beschler


"Muggins" wrote:

> Been away from ASP for way too long and just getting back in for a
> project.
>
> Using IIS and Access 2003 on the server. I can set the server to
> automatically download a text file report from a remote unix server,
> and i've linked this file as a table in access. It can do this
> periodically and then run an access macro that creates a table that my
> client can use via a web application.
>
> But sometimes we may need the client to force an update. If I
> converted the macro to VB, could this be initiated by an ASP page?
>
> Thanks.
> "Forget it Jake.....it's Chinatown"
>