Murray Brown
asked on
ASP with Access backend scenarios
Hi
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
One option is to have some sort of services (webservices/wcf services) which sit on that computer and serve the data.
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.
ASKER
Hi. Thanks very much for the answer. I had hope that this would be simple but you have cleared that up for me.