By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Designing database - continues to grow in size

P: n/a
As I create tables, establish relationships (i.e. no data yet) - the size of
the .mdb file continues to grow. So I have ~ 20 tables several
relationships .. BUT NO DATA ... and the file is up to 11 meg (early on it
was very small - then a few changes later - up to 3 meg. More changes and
now up to 11 meg). It seems as if the changes are being stored or some such
thing? What is leading to this size growth?

Any and all pointers/information much appreciated.

BBB
Jun 14 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Jun 14, 10:12 am, "booner" <b3boo...@yahoo.comwrote:
As I create tables, establish relationships (i.e. no data yet) - the size of
the .mdb file continues to grow. So I have ~ 20 tables several
relationships .. BUT NO DATA ... and the file is up to 11 meg (early on it
was very small - then a few changes later - up to 3 meg. More changes and
now up to 11 meg). It seems as if the changes are being stored or some such
thing? What is leading to this size growth?

Any and all pointers/information much appreciated.

BBB
you need to compact you database

go to Tools>Database UtilCompact and Repair Database

Jun 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.