2GB Limitation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining Text field sizes in destination Make-Table Query 3
Obtaining data from a different access database 6
outlook 2003 ost file size limitation 4
Maximum database size - linked tables in a second database 3
Make Table Query in NEW ACCESS file 1
2 gb limit and linked tables 2
find out size of each table 2
Show size of tables 1

Back
Top