splitting database

B

BruceS

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
 
T

Tim Ferguson

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
 
Top