Access 2007 – Linked tables on a web server?
We have a database used by multiple users.
Each user has the *.accdb installed on their C drive.
Each *.accdb is link to the tables on our internal server. (Using the “Link to the data source by creating a linked table” option.)
However, if we want to use the database outside our internal network, we have to use VPN to access the tables on our server, but it is atrociously slow.
I’ve tried uploading the tables to my web server, and linking the database using the www.website.com/database instead of x://servername/folder/database/tables format. But it says that it can only connect to a UNC (Universal Naming Convention).
What are the options for linking a local database to tables located on a web server so that the data can be access from anywhere in the world?
We have a database used by multiple users.
Each user has the *.accdb installed on their C drive.
Each *.accdb is link to the tables on our internal server. (Using the “Link to the data source by creating a linked table” option.)
However, if we want to use the database outside our internal network, we have to use VPN to access the tables on our server, but it is atrociously slow.
I’ve tried uploading the tables to my web server, and linking the database using the www.website.com/database instead of x://servername/folder/database/tables format. But it says that it can only connect to a UNC (Universal Naming Convention).
What are the options for linking a local database to tables located on a web server so that the data can be access from anywhere in the world?
