VB Express Database Question

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.
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top