pack tables

  • Thread starter Thread starter Ruth
  • Start date Start date
R

Ruth

Hi,there
I know with dbase or foxpro after you delete a record in a
table you can use "pack" to delete the record completely.
Is there any function or command that I can use with
Access for same purpose?
Any help would be appreciated.
 
I don't think you need to with Access.

You can "compact and repair" your database if it gets too big, but that only
affects the size after you minupulate or create and delete objects (like
forms, queries, reports, etc.) I don't think Access bloats from deleted
records like older database programs.

Rick B


Hi,there
I know with dbase or foxpro after you delete a record in a
table you can use "pack" to delete the record completely.
Is there any function or command that I can use with
Access for same purpose?
Any help would be appreciated.
 
Yes they do.

As you delete information from Access, the deleted data still bloats Access.
This is why they have Compact.
 
I disagree. The reason for compact is to compact the database after changes
are made to objects, as I previously stated. While some bloating may occur
from deleting a record (I don't think any does though) the majority of your
bloat comes from design changes. If you want to see this in action, look at
the size of your database. Add, delete, change forms and queries. Notice
the growth? Delete half your records. Notice the shrink?

Rick B


Yes they do.

As you delete information from Access, the deleted data still bloats Access.
This is why they have Compact.
 
I disagree. The reason for compact is to compact the database after changes
are made to objects, as I previously stated. While some bloating may occur
from deleting a record (I don't think any does though)
Click to expand...

You are mistaken. The space occupied by deleted records is not
recovered. Try it: create a table with 10000 records containing a 255
byte text field. Compact your database; check its size; run a delete
query to delete all those records; check its size again; compact once
more; check its size again.
the majority of your
bloat comes from design changes. If you want to see this in action, look at
the size of your database. Add, delete, change forms and queries. Notice
the growth? Delete half your records. Notice the shrink?
Click to expand...

Yes. It doesn't shrink unless you have Compact on Close turned on and
you've closed the database.
 
I agree with John.

I saw a VB application using an Access 97 database. The
client had been running this application for 2 years, and
there was no sign it had even been compacted. It was over
100 Meg.

I came in, compact/repair, and it was down to 17 meg.
This was a database that was solely used as a backend.


Chris Nebinger
 
Back
Top