Hi, I am working on a conversion project from an older Database system (Dataflex), that stored each datatable in seperate files.
I am trying to decide which is faster in Access. Continue to use the same
method of data access, putting each table in seperate Access db files, or put all the tables in a single
Access mdb file. As it is, I am doing like the original application did and opening each table with seperate connections. Since
the application has 63 different tables (some with 22,000 rows or more) I am not sure which method would be faster. I do think
that having to only make a single connection might be faster. But, I am not sure how much faster.
james