How to connect to a remote database 1

[rewdee]

Good Morning,

If I have a web page being hosted by "A". I have a small Microsoft Access database that is currently hosted by company "B" machine that is connected to the net. How do I connect to machine "B" from "A"?

Thanks,
Rewdee

 

[Nagrom]

That depends on how "B" is connected to the internet.

If it is directly connected to the internet and has File and Print Sharing enabled then you should be able to connect to it using the UNC path to the share (presuming it has some share enabled - if it is an NT 4.0 or Win2K machine there are Administrative shares enabled by default, but you have to have an account with Administrator authority on that box to access them) by specifying &quot;\\<ip address>\<sharename>&quot;.

If it's web interface is simply that of a web server then you will not be able to directly connect to that database on that machine. If the .MDB file is in a web accessible directory on that machine you could download a copy of that file, but you wouldn't actually be manipulating the original.

 

[rewdee]

Thanks for the response and I thought of creating a scheduled ftp task of copying the mdb file but I prefer to directly connect. Do you know if specifying the ip address\share will work with Windows 98.

Thanks Again,
Rewdee

 

[Nagrom]

Yes, it should work fine with Windows 98. Something you do have to consider, &quot;B&quot; must be directly connected to the internet for this [the File and Print Sharing method] to work (or at least must be on the same intranet). If you have to go through a proxy server or some other type of firewall then it won't work (a lot of web servers are setup that way so that even if File and Print Sharing are left enabled on the computer you can't get to them except through http). Also, if &quot;B&quot; is a Windows 9x machine then it doesn't have the Administrative shares enabled by default (and even when they are enabled the Administrative share is not the same as it is in NT based machines). You have to manually enablr shares on Windows 9x machines, and when you do the best security you can put on them is Share Level (you can specify a password for the share, but it doesn't require the user to have an account on that machine or anything so all).