PDA

View Full Version : Access Table Linking Question


bspahr
04-15-2003, 07:23 PM
I have an access 2000 database on a webserver that a company hosts for me.
It stores data that is input from an .asp page on my site.

I have another Access 2000 database that I want to link to this one.

I know you can use ODBC to link to SQL server.

My question is: How do you link to an access database hosted on another server?

ecnarongi
04-16-2003, 09:49 PM
if the dbs are in a secure folder you might be out of luck. if its just on the web then write to the path www.itsme.com/temp.mdb. I haven't tried this but it sounds like its possible.

bspahr
04-16-2003, 09:59 PM
The databases are not in a secure folder.
Why would I need to write to the path of the db?

I have an access db that is out on the web.
I have another access db that I want to link to the one out on the web.

I don't think this is possible unless you are using SQL server.