ASP.net with database backend

Hi

I have an Access database that sends automated reports every day through Outlook using VBA.
I want to build an online version in ASP.net for data capture. My problem is that the VBA code won't run on a web server.
How do I get around this. Do I host the tables in make it talk to my Access database on my computer? Not sure what the best route is.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Big MontyConnect With a Mentor Senior Web Developer / CEO of ExchangeTree.org Commented:
I would recommend porting the scripts over to a classic asp application, as vbScript is very similiar in syntax to classic asp. ASP.Net is not, and it would require a code rewrite to move it this kind of platform. Just do a search for "classic asp tutorials" and that should be enough to get you started.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.