HouseKeeping

[Gilbert 2097]

I'm using 2003. I have an application in which I have my Programs in one
database and my Tables, which are many, in another database. I did this just
to be able to work on my forms, reports and modules and test them w/o a lot
of clutter around. When I Create a table I do it in the Program database and
then Copyobject to the Data (table) database and then delete the table from
the Program database. The trouble is that my Program database keeps growing
in size while it's running, without me adding any more objects to it. I was
wondering if there is some residual of the tables that I deleted in there. I
know if you delete a file from the C drive that the data is still there, just
the reference in the directory is deleted. Does this kind of thing happen
when you delete a table. I've noticed the same sort of thing when I'm
developing an application. When I have deleted items and maybe rehashed them,
if I copy the whole database for backup sometimes the size is less than the
original even tho I've added several objects to it. Maybe some of the
garbage got left behind. My question is Is there some kind of housekeeping
you should do after running an app for a period of time?? Specifically to
clean out 'phantom'? tables. Thanx

 

[Sharkbyte]

Garbage information in Access? No way. <dripping sarcasm>

Access is notorious for this. You will want to go to Tools > Database
Utilities > Compact and Repair.

Also, you can go into Tools > Options > General and click on "Compact on
Close", and Access will clean up the mess every time the database is closed.

Sharkbyte

 

[Jeff Boyce]

Gilbert

In addition to Sharkbyte's response, be aware that the Compact & Repair
function (and the Compact on Close option) can sometimes fail to complete.
If this happens, your db could be corrupted beyond your wildest dreams <g>.

As a "safe computing" practice, consider creating a backup of your .mdb (you
call it "Program", the generic term is "front-end") BEFORE you try
Compact/Repair.

Good luck

Jeff Boyce
<Access MVP>

 

[Gilbert 2097]

Thank you very much for your quick reply Sharkbyte & Jeff. I haven't tried
it yet but it sounds like just the thing I need. Thanx for the warning Jeff;
I will do a backup b/4 I compact. Ciao for now,