Linking to Access DB online

[Brian Shaughnessy]

I want to have a locally stored Access DB link to an Access DB table stored
on my web-site. I thought I could just connect via ODBC, but Access won't
let you link to a Jet Database via ODBC. Any other ideas on how to do this
simply and efficiently?

-Brian

 

[Guest]

hi Brian,

To link to a database on the web site you will have to go through the web
server. You will need to add some script, for example ASP.Net to connect to
the database.

Regards,

 

[Brian Shaughnessy]

My attempt at ODBC was trying to go through the web server. I'm not sure
what you mean. Where on the Access end do I create the linked table?
-Brian

 

[Guest]

hi Brian,

You cannot create a linnked table to a database on the web site.

When your database is on a web site you will have to connect to it over the
internet (your browser will connect to the web server); unless you have
direct connection to the remote computer, for example VPN, or you are
connected to the web server through a LAN.

Since later is not likely to be the case, you will not be able to create a
MS Access ODBC connection, because it requires a physical path to be given to
locate the MS Access file.

You can however write script that executes on the web server and, retrieves
the data in a web browser. You will create an ODBC on the web server - but
this does not gives you the linked table in two access databases. You will
use any scripting language to interact with the database on the net.

You might find the article on the following link useful:
http://viu.eng.rpi.edu/lab/2/s2_2.html

Regards,