Multiple Databases

  • Thread starter Thread starter Mike
  • Start date Start date
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?

(e-mail address removed)
 
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)
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.
 
Back
Top