Link to Access DB on web server

[Carpie]

Whenever I try to link to an Access Database that is located on a web server from an Access database on my local drive, it gives the error message "Not a valid file name". What is the trick for linking into databases found on a web server?

 

[Arvin Meyer]

You need to create a DSN (Data Source Name) to connect to an Access database
on a webserver. You can also use a DSNless connection to the data, but even
then you are using similar syntax. Have a look at Carl Prothman's site for
information:

http://www.able-consulting.com/ado_conn.htm?f=ado_conn.htm

Doug Steele has a great article on DSNless connections:

http://members.rogers.com/douglas.j.steele/DSNLessLinks.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Whenever I try to link to an Access Database that is located on a web

server from an Access database on my local drive, it gives the error message
"Not a valid file name". What is the trick for linking into databases found
on a web server?