Consolidating several Access databases - performance issue

[Gurmeet]

We are in the process of redesigning a site that has
several access databases in the backend. The site
basically lets the user search the databases content. We
have several searches, and a database for each search.

My question: if the user is not editing the db content,
how many search queries can be run simultenously? I woudl
like to create a single database and move all these db's
as tables into this new database.

 

[Jeff Boyce]

Gurmeet

To get the best performance out of Access and use the "native" functions and
features, you really need your data (i.e., tables) to be well-normalized.

You haven't described the data structure, so it's a bit difficult to make
thoughtful recommendations...