I am working on a project in VB.net where I have to connect to an MS Access database that is located on a remote computer and I have to connect to it over Internet using that computer's IP Address.
Any ideas how the connection string should look like
I tried to connect to the computer by going to Start >> Run and then ran the command \\xxx.xxx.xx.xxx but it says the computer cannot be found. Is this because I'm not on the same network as that computer How will I be able to achieve the connection and be able to access the database
All Dot net gurus, I will appreciate your replies.
Thanks
Krish.
Remote Connect to MS Access DB using a static IP
Joo Lee
Hello Krish,
You can achieve this functionality by mapping a network drive using "Connect to a network server option" .
You will have to provide the internet address of the folder containing the mdb file.
HTH!
Mahesh
st3vl
Hi Krish,
If using VPN, there are many method such as windows server itself have VPN, router to router VPN, something like that. Through VPN should fix your need in theory , but also need to consider also the connection speed on both side.
The other thing I just want to give some opinion, why not try SQL 2005 Express, it's FREE. From my point of view, Access database is quite easy to corrupt.
I don't know what's type of application you are developing, but ASP.net using is a very good choice for run remote database applicaiton.
Zaremba
First thing Are you sure you Can access your Access File through \\xxx.xxx.xxx
I have no idea about how to right that string, but I remember that \\xxx is universal path seems work on local area network. Why don't you copy the access to your home,
If I think you connect the access like that, you computer (access) is very insecure,
I suggest use VPN to connect (most secure), or install a SQL then map the port to SQL server (less secure), but I sure this work.
CodeForProject
Hey Turbosolo,
Thanks for the reply.
I can connect if database is on my local computer. But I want to connect to a computer that is remote. Using Sql Server is too expensive for the budget of the project. I like your VPN idea. How do you set up the VPN to connect to that remote computer and access the database. Please give more details.
The database is located on the remote computer at location c:\MyAccess\sample.mdb which has an IP of xxx.xxx.xxx.xxx . The entire C:\ is being shared on that computer but when I try to access that IP it says 'Windows cannot find \\xxx.xxx.xxx.xxx'. I am not sure what more I need to set up.
Any further information will be appreciated.
Thanks
-Krish.