2GB Limitation

G

geebee

hi,

I have a proces that updates tables, but during this update process, the
size of the database reaches/exceeds the 2GB size limitation. Does anyone
have any ideas or strategies?

Thanks in advance,
geebee
 
J

Jerry Whittle

Describe more of what is going on with the updating.

Are you updating records from imported data? If so you could put that data
into another .mdb database file then link to the original database.

If you are moving buckets of data from one table to the next, such as
tblLastMonth, tblThisMonth, etc., that is often a sign of a bad design. If
your data isn't properly normalized, tables and databases can be much larger
nat necessary plus take more effort to keep them working.
 
Top