Database Size and Updating Queries

[StumblingThrough]

When editing fields in a (VERY large) table, why does the database size grow so dramatically (more than the size attibuted to the data being added to the table)?

During the process of running through the code (updating data in the fields), the database size hits the 2GB limit and error message appears. I then have to compact the dbase and restart the code.

Does anyone know what is causing this, and possibly a way around this?

 

[willir]

UPSDeveloper

I suspect the problem is that when Access makes a databse change, it creates working tables / backups of the tables, hence the size change.

Would creating a new database and then importing the data be a better approach? You can import just about every thing, so the bulk of the work will be recreating the tables.

Or perhaps create a new database with only the table(s) in question with the larger fields - import the data into the new database - delete the old tables in question -- import the revised tables from the new databse back to the original database.

Another approach would be to break your tables up into two database and link your front end database to the two back end databases.

Richard