Hi, I have a question. I need to be able to connect to a local access db via my internet site. So the code will reside on IIS(web hosting machine), but the db will be on the client machine locally. How can I connect to the local access db on the client machine
? How do I manage my updates from the Webserver to the Local db ?
To connect to the database you need to be able to make a network connection to it from the web server. I haven't tried that sort of thing with MS Access but I suppose it should be possible. You may need to map a drive letter from the webserver to your local
machine so that you can point to it something like "x:\SomePath\MyAccessDB.mdb" in your connection string. But depending on where your site is hosted I wouldn't be surprised if there are firewall issues that will prevent this.
zubair_hussa...
Member
20 Points
4 Posts
Connection to local database...can it be done ??
Aug 05, 2003 05:46 PM|LINK
McMurdoStati...
Contributor
3015 Points
601 Posts
Re: Connection to local database...can it be done ??
Aug 05, 2003 08:52 PM|LINK