View Full Version : Can I link to tables in an access database on a web server?


MatMac
09-03-2009, 05:14 AM
Hi

I maintain a multi-user Access database split into front and back ends. The front end contains some rather complex reporting systems.

I would like to create a simple web-based front end to this database for users to enter data, but also need to permit a couple of administrators to access the data via the original Access front end in order to run the reporting systems. I plan to create my simple web-based interface using ASP.NET.

Is it possible for me to set up my original front end to link to the data tables, if the back end is placed on a web server? (As it would need to be to permit the web-based interface to operate.)

If so, how, and are there any other issues I need to consider?

Many thanks

Mat

ajetrumpet
09-03-2009, 07:08 PM
mat,

just thought i'd mention this...

the only thing i've done with access data on the web is displayed data tables by setting up DSN connections. this is quite easy, as a google search will yield this for you.

just thought i'd mention...