splitting database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK, guys, one of my A2K databases has finally gotten too big, fat and slow
and I need to split it into front and back ends. Can anyone suggest good
online reading that covers the basics and offers some tips and code snippets?
Tks,
Bruce
 
one of my A2K databases has finally gotten too big, fat and slow
and I need to split it into front and back ends.
Click to expand...

Bear in mind that splitting a database is not meant as a cure for bigness,
fatness or slowness. Each of those symptoms may have one or more causes,
but none will be helped by a FE/BE split. You may find that it runs slower
afterwards than before.

Which is not to say that you shouln't split it - quite the reverse. The
purpose of splitting a mdb is to avoid file corruption, improve multi-user
reliability, avoid file corruption, make maintenance easier, avoid file
corruption, improve working over the network, and avoiding file corruption.
Did I mention that it will make file corruption less likely too?

All the best



Tim F
 
Back
Top