VB Express Database Question

  • Thread starter Thread starter Martin Horn
  • Start date Start date
M

Martin Horn

Hi,

I'm using VB Express 2005 and I want to write an application that uses an
access database, but the location of the database file will be on a remote
PC on a LAN and so I need to be able to specify the connection string at
runtime. I also need to have simultaneous connections by up to 5 clients.

Can anyone suggest the best approach for this, as all the examples and
wizards I can find seem to hard code the connection string and make it read
only, and only support one connection at a time.

I wrote something similar with VB6 using DAO which worked exactly how I
wanted, and I imagine I could take the same approach with VB Express and add
a reference to MS DAO 3.6, but I'm sure that isn't the best way to go about
it.

Any suggestions or pointers in the right direction would be greatly
appreciated.

Kind regards,

Martin Horn.
 
Hi again,

well I've come up with a working solution at least, by using an Access
database with OLE DB and editing the
TableAdapter.Connection.ConnectionString to point to the database.

As you can tell I'm a real beginner so I'm still open to suggestions if
anyone can think of a better way to achieve this.

Thanks.
 
Back
Top