How to decrease database size?

[Sirritys]

Hello,

I'm having interesting dilemma. I made a copy of an database and then
removed all tables and queries I didn't need. (Fast way to pick those
which I want)

Now the thing is that even thgouht I removed almost all tables the size
of the database is still the same (about 500Mt).

How can I actually get the unwanted data deleted from database ?

Yours,
Sirritys

 

[tina]

run a compact/repair on the database. from the menu bar, choose Tools |
Database Utilities | Compact

hth

 

[Sirritys]

Thx,

Didn't found that one =)

 

[Guest]

what does that actully do?
I have been woundering it for a long time, cause if i delete all data
manully inside the access, it says its "empty" but when i right click on my
database file, i can still find some text from data i have delete by hand
inside the programm.

But when i run the tool Compact and repair it actully takes that away.

 

[John Vinson]

what does that actully do?
I have been woundering it for a long time, cause if i delete all data
manully inside the access, it says its "empty" but when i right click on my
database file, i can still find some text from data i have delete by hand
inside the programm.

But when i run the tool Compact and repair it actully takes that away.

When you delete data in a database, it's not actually removed - it's
just flagged as being deleted. It's not clear why, but there's no
provision for "undeleting" - but the data is still there on disk.

Compaction actually creates a new empty database (named db1.mdb if
there isn't already a database of that name); all of the objects in
your database are then copied into the new one. Table data is appended
from the records which aren't flagged as being deleted; the "deleted"
records are left behind.

After everything is copied, the old database is deleted and the
db1.mdb is renamed to the new name.

This is why you can sometimes find a db1.mdb file sitting in the
folder with your database if something goes wrong in the compaction
process.

John W. Vinson[MVP]