ASP with Access backend scenarios


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 to query the Access queries.Is this possible?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
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.
One option is to have some sort of services (webservices/wcf services) which sit on that computer and serve the data.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi. Thanks very much for the answer. I had hope that this would be simple but you have cleared that up for me.
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.