Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2006

Tip: Looking for answers? Try searching our database.

splitting database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BruceS - 02 Feb 2006 05:39 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.