Consolidating several Access databases - performance issue

  • Thread starter Thread starter Gurmeet
  • Start date Start date
G

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.
 
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...
 
Back
Top