I have a database working with VB6 and Jet. Everything works fine except that I now need the database to be accessed from a second machine on the network.
It appears that only one person can be connected at a time to the database using Jet, is this correct?
In the 'DefaultType' of the data method it has the option for Use ODBC, which, from my research, appears to be a more recent and flexible way to access databases. Is this what I need to use to get shared connections to the database?
Is so how do I use it? If I select it and run I get a 'Data source name too long' error.