Access VB code from an ASP

[Mike Ridley]

I have just inherited an Access Booking Application. Works fine,
including some quite complex code that calculates an availability
table from dates input by the user.

I have produced a simple asp to display this table in a browser.
I can write a form for the user to input the dates through a browser
but what is the best way of executing the Access VB code from my asp
(avoiding copy and paste)

Thanks

Mike

[Larry Linson]

If you have Access installed on the server, which is not normally the case
with asp using a Jet database (only the Jet database engine is installed on
the server), you could execute the VBA through COM automation. asp pages, as
you know, do not execute VBA -- as close as they can come is to execute
vbscript, a subset of VB. Cutting and pasting your VBA will not work, sad to
say.

Larry Linson
Microsoft Access MVP

"Mike Ridley" <gi******@hotmail.com> wrote in message
news:e5**************************@posting.google.c om...

I have just inherited an Access Booking Application. Works fine,
including some quite complex code that calculates an availability
table from dates input by the user.

I have produced a simple asp to display this table in a browser.
I can write a form for the user to input the dates through a browser
but what is the best way of executing the Access VB code from my asp
(avoiding copy and paste)

Thanks

Mike