12MB database with nothing in it!

[yhgtbfk]

I had a database that was 25MB. Due to people changing their minds I have to delete an entire section of the database that took up nearly 1/3 of it. Yet I noticed that the space it occupies didnt go down much - even after a compact and repair.

So I made a copy of the database and started deleting tables at random to see the difference it made.

After deleting everything (tables, queries, forms, reports) it is still 12MB.

What is taking up 12MB? My database does have custom images on the buttons but I thought once the form is deleted the images will go with it.

Is there anything Im overlooking? I know 12MB isn't much compared to some databases alot of you people have but it is annoying me.

Thank you in advance

 

[ghudson]

Your Access db will be severly bloated when you add or import any type of graphics. Access will convert the graphics into a bitmap. Make a copy of your db, delete the graphics [custom buttons] and see how small it gets after you compact it.

 

[yhgtbfk]

Ghudson do you mean delete the link to the images before deleting the buttons?

Because I have deleted every form - taking with it all the images - yet it is still 12MB.

I made a copy of the database and deleted absolutely everything - yet it is still 12MB.

I wonder if access is hanging onto the images somewhere.

 

[ssteinke]

Have you tried to decompile, try this:

from Start/Run: use this command

"Location of access" "Location of DB" /decompile

For example:
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\mydatabase.mdb"/decompile

then compile and compact & repair

be certain to save a copy of your database before using decompile

hope this helps,

Scott