Multiple Databases

M

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?

[email protected]
 
J

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?

[email protected]
Click to expand...

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