I've noticed that after I've compacted a Access 97 back end (split 

design), that some of the list boxes don't work on the front end. Do I 

have to refresh the linked tables?



I've also noted that in trying to compact a larger back end Access 97 db

(30 megs), the compaction operation failed. I haven't done a lot of 

compacting on this one so should I start a new db and import all the 

tables then recompact?



I've not seen a lot discussion on this topic including the MS site.



Any advice or suggestions would greatly be appreciated.



PS - I'm new to this board but I intend to come back often to see what 

types of issues are facing access developers of which I'm just moving to 

Access 2000 and beginning on using the SQL server. I just got Mr. Dobson 

book.



Regards

Steve Fredrickson

I only compact the front end. I believe that compacting affects forms and

reports, but not the actual table data. (I could be wrong about this.) 



Miriam Engelberg

Technology Faculty/Chief Cartoonist

CompassPoint Nonprofit Services

www.compasspoint.org

(xxx) xxx-xxxx





-----Original Message-----

From: Steve Fredrickson [mailto:fredrisg@h...]

Sent: Tuesday, June 12, 2001 4:02 PM

To: Access

Subject: [access] Compacting issues with Access 97





I've noticed that after I've compacted a Access 97 back end (split 

design), that some of the list boxes don't work on the front end. Do I 

have to refresh the linked tables?



I've also noted that in trying to compact a larger back end Access 97 db

(30 megs), the compaction operation failed. I haven't done a lot of 

compacting on this one so should I start a new db and import all the 

tables then recompact?



I've not seen a lot discussion on this topic including the MS site.



Any advice or suggestions would greatly be appreciated.



PS - I'm new to this board but I intend to come back often to see what 

types of issues are facing access developers of which I'm just moving to 

Access 2000 and beginning on using the SQL server. I just got Mr. Dobson 

book.



Regards

Steve Fredrickson

If you remove records from a table, Access does not decrease the size of th

e table. The only way to recapture that space is to compace. I have Access 

routines which import and prepare csv files for transfer to SQL Server whic

h swell to 600+ MB. Once I've cleared down the tables, I can reduce the fil

e size to 3 or 4 MB by compacting.



Beverly

Steve -

 I'd suggest trying to create a new mdb and importing the data. Then see if

it compacts. You might run into ram troubles or something like this with a

large DB like you have, or there might just be some other cause (is the mdb

still in use or do you have exclusive lock on it?).



 Miriam-  compacting removes all left over residue from forms, etc created

when designing them. Unless you are making new (or editing existing)

forms/reports, once they have been compacted, the won't be affected by any

further compacts. The data however will almost always be affected. Every row

you delte is still in the DB until you compact it...



  Randy

>

> Subject: Compacting issues with Access 97

> From: "Steve Fredrickson" <fredrisg@h...>

> Date: Tue, 12 Jun 2001 23:01:56

> X-Message-Number: 1

>

> I've noticed that after I've compacted a Access 97 back end (split

> design), that some of the list boxes don't work on the front end. Do I

> have to refresh the linked tables?

>

> I've also noted that in trying to compact a larger back end Access 97 db

> (30 megs), the compaction operation failed. I haven't done a lot of

> compacting on this one so should I start a new db and import all the

> tables then recompact?

>

> Regards

> Steve Fredrickson

>

> ----------------------------------------------------------------------

>

> Subject: RE: Compacting issues with Access 97

> From: Miriam Engelberg <MiriamE@c...>

> Date: Wed, 13 Jun 2001 09:18:49 -0700

> X-Message-Number: 2

>

> I only compact the front end. I believe that compacting affects forms and

> reports, but not the actual table data. (I could be wrong about this.)

>

> Miriam Engelberg

> Technology Faculty/Chief Cartoonist

> CompassPoint Nonprofit Services

> www.compasspoint.org

> (xxx) xxx-xxxx