One file or multiple files

[Pierre]

Hi all,

In one application i want to use one of three external look-up tables in mdb
format.

(I use openforseek() to makeindexed search in external mdb)

Knowing that i will always use one of the three tables depending on the
costumer i choose,
is it better to:

A- have the three table in three external database so when i open a table it
is smaller and should go faster

or to

B-Put the three tables in the same mdb external files. Access will search in
only one of the files and the size of the mdb is not important.

Best regards
pierre

 

[Guest]

This all depends on the size of you DBs.

I would suggest A if the file is really small because it's easier to reference
Access is optimized to retrieve data from the file.
If there is a real performance issue then i would use SQLserver/MSDE

- Raoul

 

[Guest]

One Table with a field that will identify the costumer. Make your record
source a query with that field with a parameter so that when you select a
costumer, the query will return the records for that costumer only.