Exploding db size ACC 2000

[Rita]

Hi Everyone,

Hope someone can give me a pointer to what's happening. I
am importing records from Oracle. I convert the data and
bring it into an edit table which has about 20 columns and
12000 rows for clean up purposes. Everything goes ok until
I trim text from OriginalData column (250 characters)and
write it to NewData column (16 characters). When I do
this, the db size increases from 6 mb to 150 mb.

Any help would be appreciated.

Rita

 

[david epsom dot com dot au]

dunno - but check your release numbers for A2K.
Dot Zero release had some bloat problems (you should
be on SR3). Apart from that, compact, repair, create
new database - it might be just a corruption problem
with your existing db.

(david)

 

[Al]

This tip involves reducing the size of your database even
after it has been compacted. Here's a little tip.
To reduce the size of a db you can use the following trick.

NOTE: Use this on a copy of the database.
Open the copy and rename the autoexec macro so the db
would not start automatically and close the db.
Create a shortcut to the copy of your mdb.
Open the properties of the shortcut.
In the target, enter the following:
"C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" "C:\Documents and
Settings\blah\Desktop\Copy of MyDB.mdb" /decompile
Check the path to access and to the copy of your .mdb and
the name you give to the copy and close the shortcut.
Double click on the shortcut to open the copy of the db.
Open a module and select the menu Debug and compile the
database.
Close it and look at the size. It should have decreased
dramitcally.