VB6 + ACCESS on LAN

[Dave Clements]

I have a flat file MS Access DB that shows customer details.
I would like to access it over a LAN (using a hub in star formation) using a
VB front end so all 4 PCs can look at it
So far all the PCs are set for file sharing and I have created a shared
folder with the DB in it on one PC
I can build a connection string on this PC and eveything works fine ,
Question is how to connect the ADO data control to it on the other PCs

Thanks
Dave Clem

[Paul Clement]

On Mon, 30 Sep 2002 17:23:47 +0100, "Dave Clements" <david.clem@btinternet.com> wrote:

¤ I have a flat file MS Access DB that shows customer details.
¤ I would like to access it over a LAN (using a hub in star formation) using a
¤ VB front end so all 4 PCs can look at it
¤ So far all the PCs are set for file sharing and I have created a shared
¤ folder with the DB in it on one PC
¤ I can build a connection string on this PC and eveything works fine ,
¤ Question is how to connect the ADO data control to it on the other PCs

You can specify the location in the ConnectionString property of the ADO Data Control:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ServerName\ShareName\dbfolder\db1.mdb


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)