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

iown714 · Aug 2nd, 2005, 9:54 PM

Hi,
I'm trying to write just a simple VB application that runs on machine X and accesses an Access table on machine Z. I don't really want to map any drives or such thing. Machine X and Z are in the same network so they can see each other. Does anyone know what the connection string would be for the application to access the table?

Let's say that I want to retrieve all records whose customers whose first name is = "mark". The basic structure to open a db is...

Set dbsCurrent = OpenDatabase("xxxx")

... and then what??? what is the next thing that I have to do to get all the records from machine Z to machine X? What is the exact connection string that I have to use in order to access an Access database over the network?

Thank you in advance.

Aug 2nd, 2005, 9:54 PM	#1
iown714 Newbie Join Date: Aug 2005 Posts: 1 Rep Power: 0	How to connect with VB to an Access database on another computer Hi, I'm trying to write just a simple VB application that runs on machine X and accesses an Access table on machine Z. I don't really want to map any drives or such thing. Machine X and Z are in the same network so they can see each other. Does anyone know what the connection string would be for the application to access the table? Let's say that I want to retrieve all records whose customers whose first name is = "mark". The basic structure to open a db is... Set dbsCurrent = OpenDatabase("xxxx") ... and then what??? what is the next thing that I have to do to get all the records from machine Z to machine X? What is the exact connection string that I have to use in order to access an Access database over the network? Thank you in advance.