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
Jeff Conrad - 02 Feb 2006 05:43 GMT
This should cover it pretty well:
http://home.bendbroadband.com/conradsystems/accessjunkie/splitting.html

Signature
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html
> 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?
BruceS - 02 Feb 2006 06:16 GMT
Thanks, Jeff!
Bruce
> This should cover it pretty well:
>
[quoted text clipped - 3 lines]
> > 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?
Jeff Conrad - 02 Feb 2006 06:26 GMT
You're welcome, good luck with your project.

Signature
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html
> Thanks, Jeff!
> Bruce
Tim Ferguson - 02 Feb 2006 20:49 GMT
> one of my A2K databases has finally gotten too big, fat and slow
> and I need to split it into front and back ends.
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