Programming Forums - View Single Post - How to connect with VB to an Access database on another computer

Pizentios · Aug 3rd, 2005, 10:45 AM

i could be wrong but i think you need a service to run on box Z to serve the db up.

Why are you using access? there are far better db's out there (that are commercial quality) that are free (read: free as in beer). Like Postgresql and MySQL

I like postgresql myself, but many others will tell you mysql. VB will connect to these two no problem.

If you still want to use a access db, you'll need box Z to run IIS (or personal web server), and then have a DSN pointing to your db. Then connect with something like this:

(Toggle Plain Text)

Dim cnnConnection as Connection

set cnnConnection = new Connection

cnnConnection.Open "Provider=MS Remote;" _
	& "Remote Server=http://www.myserver.com;" _
	& "Data Source=MyDataSource;" _
	& "User Id=MyUserName;Password=MyPassword;"

Then all you'd have to do is run a query, and output the data or do what ever you need to do with it.

Note: You do not need to put a web address into the Remote Server Part of the connection strings, you could use something like http://192.168.0.11 or what ever the internal ip of box Z is.

Also i have no idea if you can use apache (a free and better web server IMHO) for this or not, so your on your own for that part :-)

Aug 3rd, 2005, 10:45 AM	#2
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	i could be wrong but i think you need a service to run on box Z to serve the db up. Why are you using access? there are far better db's out there (that are commercial quality) that are free (read: free as in beer). Like Postgresql and MySQL I like postgresql myself, but many others will tell you mysql. VB will connect to these two no problem. If you still want to use a access db, you'll need box Z to run IIS (or personal web server), and then have a DSN pointing to your db. Then connect with something like this: (Toggle Plain Text) Dim cnnConnection as Connection set cnnConnection = new Connection cnnConnection.Open "Provider=MS Remote;" _ & "Remote Server=http://www.myserver.com;" _ & "Data Source=MyDataSource;" _ & "User Id=MyUserName;Password=MyPassword;" Dim cnnConnection as Connection set cnnConnection = new Connection cnnConnection.Open "Provider=MS Remote;" _ & "Remote Server=http://www.myserver.com;" _ & "Data Source=MyDataSource;" _ & "User Id=MyUserName;Password=MyPassword;" Then all you'd have to do is run a query, and output the data or do what ever you need to do with it. Note: You do not need to put a web address into the Remote Server Part of the connection strings, you could use something like http://192.168.0.11 or what ever the internal ip of box Z is. Also i have no idea if you can use apache (a free and better web server IMHO) for this or not, so your on your own for that part :-) __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007! Last edited by Pizentios; Aug 3rd, 2005 at 11:10 AM.