[Last Call] Learn how to a build a cloud-first strategyRegister Now


ASP with Access backend scenarios

Posted on 2011-10-18
Medium Priority
Last Modified: 2012-05-12

I have a client that has an Access database where he binds queries to a form
so that the user can see a list of his suppliers and then click on the + to drill down and see products relating to a specific supplier.
I am used to having an Access database on an international server, but he seems to think that
for his purposes the Access database should sit on his LAN at work (where Access is loaded).
The idea is to use ASP.net to query the Access queries.Is this possible?
Question by:Murray Brown
  • 2
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 36985873
Access doesn't support remote connections, so unless the server hosting the ASP.NET app can "see" the location of that Access database, it won't work.

It's not different than trying to connect to a web-based Access database from your workstation. Unless you can navigate to that location through a standard Windows Explorer interface, you cannot connect to it from your desktop. The same concepts apply in reverse.

Depending on how dynamic your data needs to be, you could just export the data to a web-based Access db at pre-determined intervals (every day, for example, or every week - whatever best suits your needs) and your ASP.NET app could then use that data. This could be a manual process, or you could perhaps develop a small .NET app that would move the exported data to the web server.
LVL 83

Expert Comment

ID: 36986500
One option is to have some sort of services (webservices/wcf services) which sit on that computer and serve the data.
LVL 85
ID: 36986546
But how would the web service get to that LAN-based database? The process would have to be on the LAN-based workstation (i.e. the Access database). That db would have to export the data (perhaps to a CSV file), and the webservice could then perhaps move the data up to the server (or just build datatables and such that the ASP.NET app could use) - but the webservice would have to be able to get to that data on the LAN, of course.

Author Closing Comment

by:Murray Brown
ID: 36988410
Hi. Thanks very much for the answer. I had hope that this would be simple but you have cleared that up for me.

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

834 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