PC Review


Reply
Thread Tools Rate Thread

Compacting front ends and back ends

 
 
Deb Struble
Guest
Posts: n/a
 
      11th Sep 2003
If I compact my front-end database, does that automatically compact the
back-end linked tables? Not sure if I have to go into both the front-end
and back-end to compact?
Thanks!


 
Reply With Quote
 
 
 
 
Gina
Guest
Posts: n/a
 
      15th Sep 2003
You have to compact all front-ends and the back-end seperately.

"Deb Struble" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If I compact my front-end database, does that automatically compact the
> back-end linked tables? Not sure if I have to go into both the front-end
> and back-end to compact?
> Thanks!
>
>



 
Reply With Quote
 
Tim Ferguson
Guest
Posts: n/a
 
      15th Sep 2003
"Deb Struble" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

>
> If I compact my front-end database, does that automatically compact the
> back-end linked tables? Not sure if I have to go into both the front-end
> and back-end to compact?
>


There is not really much point in compacting the front end file: it would
normally not be subject to much inserting/ deleting (some would say any)
and if it should get bloated it would be simpler and safer just to download
a new copy.

Backend compacting is a good idea, as a companion to backing up -- but do
the backup first!

All the best


Tim F

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two Front Ends, One Back End =?Utf-8?B?SmFuZXRG?= Microsoft Access 5 7th Sep 2006 07:10 AM
One Front End with Multiple Back Ends =?Utf-8?B?U3RldmUgRA==?= Microsoft Access Database Table Design 1 30th May 2006 04:28 PM
One front end with multiple back ends =?Utf-8?B?Y2hlc3Rlcm1hbg==?= Microsoft Access Database Table Design 2 25th May 2006 02:25 PM
Access front & back ends Tcs Microsoft Access VBA Modules 4 17th Nov 2004 07:59 AM
Close Front ends from the back end rosco Microsoft Access 0 14th Sep 2004 07:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:50 AM.