ASP with Access backend scenarios

Posted on 2011-10-18
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 to query the Access queries.Is this possible?
Question by:murbro
    LVL 84

    Accepted Solution

    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

    One option is to have some sort of services (webservices/wcf services) which sit on that computer and serve the data.
    LVL 84
    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

    Hi. Thanks very much for the answer. I had hope that this would be simple but you have cleared that up for me.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    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…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    737 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

    16 Experts available now in Live!

    Get 1:1 Help Now