Access 2003

[danzasmack]

I have a large DB of financial data. When i compact it, the Db is about 500MB, but when I, say, add a column to a table, the DB can go to 2GB very quickly. The amount of data i add in comparison to the size of the DB is very small. Howver, i am editing a recordset to do so.

Also, as you may know, if an access DB gets to a certain size (over 2GB about) you will simply get the error "invalid argument" when you try to add a record.

Any advice in managing this besides compacting every day. (when i compact it goes down to about 500mb)