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 / General 1 / June 2006

Tip: Looking for answers? Try searching our database.

Compact & Repair Questions Access2000.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ApexData@gmail.com - 23 May 2006 00:26 GMT
Hello

I have finally completed an application and am preparing to install it
on a network of 10 users.
The application will be split FE/BE.  The application has its own
login, which controls the
users ability to either ViewOnly or FullRights. Using Access2K.  20MB
Database.

My questions pertain to CompactOnClose:

1- How often?
2- For lack of a better option, I have choosen the option
Tools->Options->CompactOnClose as Checked. Is this an acceptable
practice for Compact & Repair, since it seems that every
time a user closes (ie EACH-DAY/EACH-USER) the CompactOnClose fires
regardless of
the user having made changes or not. Is this too often, will this cause
more harm than good ?
3- Does the CompactOnClose affect the FE for each user and the shared
BE  ?
4- When fired, does a Compact & Repair take place or Is it a Compact
all the time and a Repair only if needed ?
5- How do the pros typically manage Compact & Repair ???

ThankYou
Greg
Ron2006 - 23 May 2006 14:00 GMT
The Compact and Repair affects the file that is opened NOT the linked
tables.

So in your case it will affect the FE mdb file only.

C&R obviously requires EVERYONE to be out of the mdb when it is done,
so there is no easy automatic way to do it from one of the FE. C&R can
be done from another mdb but still has the constraint that NOONE is in
it.

In our case we do it weekly and manually, but we have a high use
application, However we also have people coming in at an early hour so
one of them has been trained to do it.
ApexData@gmail.com - 05 Jun 2006 23:28 GMT
Thankyou for the response Ron.
Also, the following link answered many of my questions:

www.access.qbuilt.com/html/gem_tips1.html#SplitDB

Greg
 
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.