File Size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce - 13 Apr 2005 08:53 GMT

I had to do an Access 97 Database that joined 6 other tables to a maindata
table so I could filter out cases that appeared in the 6 sub tables. Having
done this the rows reduced from 36,000 to around 7,000. However the overall
file size has remained at 13 mgb.Why?

Best Wishes
Bruce
( Illegitimi non carborundum est )

Reply to this Message

Ofer - 13 Apr 2005 09:49 GMT

I undrtand that the table became smaller, withe less data,
and you are not talking about using a query.

In that case did you compact your DB after reducing the
data in your table?

>-----Original Message-----
>I had to do an Access 97 Database that joined 6 other tables to a maindata
[quoted text clipped - 7 lines]
>
>.

Reply to this Message

Bruce - 13 Apr 2005 09:57 GMT

How do you compact a Access 97 database?

After updating the main table I deleted the 6 sub tables & reduced the
maindata table down to 7,000 rows.

> Best Wishes
> Bruce
> ( Illegitimi non carborundum est )

Reply to this Message

Ofer - 13 Apr 2005 10:06 GMT

Open the database you want to compact
On the menu bar select:
Tools ->
DataBase utilities ->
Compact databse

that will do the trick

>-----Original Message-----
>How do you compact a Access 97 database?
[quoted text clipped - 7 lines]
>
>.

Reply to this Message