Multiple Databases

[Mike]

I want to set up multiple databases due to the volume nd
complexity of data. Where can I find info to help in
design to eliminate pitfalls and how to interface
multiple databases?

(e-mail address removed)

 

[John Vinson]

I want to set up multiple databases due to the volume nd
complexity of data. Where can I find info to help in
design to eliminate pitfalls and how to interface
multiple databases?

(e-mail address removed)

If you have more than 2 billion bytes of data (perhaps five or ten
million records in the largest tables), you should very strongly
consider moving to a true client-server architecture such as SQL
Server, Oracle, or MySQL (while using Access as a frontend). Access is
pretty powerful but it does have limitations - and the 2 GByte limit
is not the only (or even the most critical) one.