how many times can you open a database?

if my control is data1(0)

would it be possible to have data1(0), data1(1) and data1(2) all searching through the same database for different strings of info at the same time?

if this can be done, how many instances of "data1" can i have doing this to the same database at the same time?

thanks :)

access can have upto 255 concurrent users.

My advice would be to steer away from data controls and use ADO like in the very top thread in this forum.

cheers
b :)

StangerD5,

As Beacon states use ADO and do no use more that one connection to a database unless you seriously know what you are doing and if you know how to multithread an app.

That is the only way you will truely get three searches going at the same time in one program (of course the database engine must be able to handle multiple threads also).

NOTE: Managing more that one connection in a program to the same database incorrectly can cause database crashes and instabilities.