Linked tables to a database on a web server

Phonik

Registered User.
Local time
Today, 06:30
Joined
Sep 22, 2006
Messages
111
Hi

Can anyone tell me if this is possible? Please!!
I am trying to create a linked table within Access 2000 and when it asks me for the path, I am tying in the address of my web server Http://www.....and then when I enter my username and password, it shows me the folders within my web space along with the icon for the access database I am trying to connect to. When I double click the database, it does show me the list of tables however it is showing them off my local computer and not the online database. (The databases are exact copies of eachother)
I know this becasue I have entered data in the apparantly linked table and it shows up in the table on the local machine. Access does not seem to like this.
Can anyone suggest how I overcome this at all? Thanks in advance.... :-)

Gareth
 
I suspect that you need to specify the link as a full path something like

\\webserver\sub folder\database name

I have databases using tables linked from a web server and this method works fine

You do of course need full network permission to get to the web server

L
 

Users who are viewing this thread

Back
Top Bottom