Solved

ASP.net with database backend

Posted on 2011-03-15
2
237 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:murbro
2 Comments
 
LVL 32

Accepted Solution

by:
Big Monty earned 500 total points
ID: 35141566
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
 

Author Closing Comment

by:murbro
ID: 35166645
thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now