Hi!

As Access databases (*.mdb) tend to get bigger and bigger, Access itself

as a feature that compresses the database. What does this feature do? Is

this an integral part of the JET engine or is it just a "SELECT * INTO
xyz FROM abc" ?

Thx
chris

You can, in some respects, look at an Access application as though it were
a gigantic database.  When you delete an object, the information about the
object does not immediately get removed from the file, rather it gets
marked as deleted, just like deleted records in a database table are not
immediately removed.  The compact operation of Access performs the actual
housekeeping, physically removing deleted information and reordering the
mdb to the most efficient structure.  So the mdb does not actually get
"compressed" except in the sense that throwing away the deleted info
reduces the file size; it is not like an actual "pkzip"-type compression of
bytes..
--
Pete B

On Thu, 01 Jan 1998 13:00:13 +0100 in comp.databases.ms-access,

It purges out space left over by deleted objects.
This should be done on a regular basis, like defragging your hard disk,
it effectively defrags your database as well (makes all tables
contegous).

                    \|||/
                    /   \
                   C o o D
-----------------ooO--u--Ooo-------------------------------
To reply my mail, replace the "nospam" in my address with "trevor",
this was put on in defence of the spam robots that roam usenet.

MS Access FAQ now available on my site below.
http://easyweb.easynet.co.uk/~trevor/

Apathy Error: Don't bother striking any key.