Table Size Limit

[StumblingThrough]

I have written a module that updates two fields in every record in a table that is over 3M records. As I crank through the code (and editing the table), I continue to get an error message at the 'rs1.update' line as the database size grows. I believe it has to do with table size. Any ideas? And what are the table size limits if there are any?

 

[DoubleD]

Why are you having to update 3M records constantly? I'm not sure what your database is for, but I would think one of two things applies here.
1. Your database structure needs to be changed.
2. You should be using dedicated program or VB app instead of Access.

I am what I am based on the decisions I have made.

DoubleD

 

[StumblingThrough]

It's not a constant update. It's a one-time deal.

However, I was able to get it to work by separating the table into one database, and the code (module) into another, and linking to the database containing the table. When doing so, the database size of both databases stayed relatively constant, with the database containing the table only growing slightly, as you would expect due to the addition of a few characters in most records.

I believe the problem actually had to do with something access doing behind the scenes - maybe for some type of undo functionality. However, when updating a linked table, it does not try this. Just guessing...