 |
28-Jul-2006, 08:37 AM
|  | Guest | | | | | | | | | | Re: Compact & Repair Question
check http://www.mvps.org/access
Pieter
"StuJol" wrote in message
news 727278B-159B-476A-991D-931BD913B8F5@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13417
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13417
>i have a FE & BE database. Both databases are set to compact on close via
>the
> tools-options-general tab.
>
> This doesnt appear to work on split databases? any ideas on a way round
> this?
--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4231 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len
|
28-Jul-2006, 08:37 AM
| | Guest | | | | | | | | | | Re: Compact & Repair Question
On Mon, 17 Jul 2006 18:27:02 -0700, StuJol wrote:
>i have a FE & BE database. Both databases are set to compact on close via the
>tools-options-general tab.
>
>This doesnt appear to work on split databases? any ideas on a way round this?
The backend will only compact when the LAST frontend disconnects from
it. If user A closes her database but users B, C and D have it open,
it will detect that the database is in use and not attempt to compact.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13417
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13417
There is probably little benefit from compacting the frontend.
Normally the frontend won't contain any tables in any case! It may
bloat somewhat from queries and Microsoft-generated temp tables, but
it can be simply replaced with a new copy of a "fresh" backend as
needed.
John W. Vinson[MVP]
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Active Discussions | | | | | | | | | | | | | | | | | | | | | | | | | | | Panjabi Today 02:27 AM 11 Replies, 238 Views | | | | » Books You Should Read... | | | |
All times are GMT +6.5. The time now is
20:34 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Search Engine Optimization by
vBSEO 3.6.0 PL2
Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network
