A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Compact back-end database



 
 
Thread Tools Display Modes
  #1  
Old January 14th, 2009, 05:40 PM posted to microsoft.public.access.gettingstarted
Michael
external usenet poster
 
Posts: 57
Default Compact back-end database

Hi Folks - Question ... I have a FE and BE Access 2000 database
configuration. If I choose the option to compact on close for the BE
database, will it be compacted, or do I need to explicitly open and close
the BE db. If so, what techniques are people using to automatically compact
the BE db? Thanks.

Michael


  #2  
Old January 14th, 2009, 05:52 PM posted to microsoft.public.access.gettingstarted
Roger Carlson
external usenet poster
 
Posts: 824
Default Compact back-end database

I never compact my databases (FE or BE) automatically. However, when I do
want to compact the BE, I use a process similar to my CompactBackEndDB.mdb
sample, which you can find he
http://www.rogersaccesslibrary.com/f...ts.asp?TID=378


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Michael" wrote in message
...
Hi Folks - Question ... I have a FE and BE Access 2000 database
configuration. If I choose the option to compact on close for the BE
database, will it be compacted, or do I need to explicitly open and close
the BE db. If so, what techniques are people using to automatically
compact the BE db? Thanks.

Michael




  #3  
Old January 21st, 2009, 06:54 AM posted to microsoft.public.access.gettingstarted
Boyd Trimmell aka HiTechCoach via AccessMonster.com
external usenet poster
 
Posts: 45
Default Compact back-end database

Michael wrote:
Hi Folks - Question ... I have a FE and BE Access 2000 database
configuration. If I choose the option to compact on close for the BE
database, will it be compacted, or do I need to explicitly open and close
the BE db. If so, what techniques are people using to automatically compact
the BE db? Thanks.

Michael


Michael,

The compact on close only work when the Access EXE file open the database
and then closes it. It codes not work on a back end when the front end closes.


I normally do not use the compact on close. I find it best to backup a
database before the compact/repair is run.

Also yo can not compact a back end will there are in users the front end is
accessing it.

I like to use a scheduled task to ZIP and compact each back end.
Here is an example: http://www.peterssoftware.com/cal.htm

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.