Solved

ASP.net with database backend

Posted on 2011-03-15
2
269 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 33

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

705 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