>For some reason, when I try to insert a record to a table with about 700K records (not many fields) in it, I am getting the following: "There is not enough memory to complete this operation (Error 43)" - From the exe that is doing an INSERT this shows as an error going to the error log file, but until the user clicks OK on the dialog the table is locked and this really causes problems for other users. Any thoughts about why a program would have this issue even when the PRG/DBF, etc have not changed in some time? In VFP7 Development, if I insert a record (blank) I get this error but if I click IGNORE it goes on. As well, the app seems to complete but it closes out. Should I just trap 43 and do nothing with it? Is that the only way out?

Hi Doug

NEVER ignore errors. Find out the cause. At least you'll learn something! It used to be that there was some difference in Rushmore memory usage for index files around the 500K record mark. Things would be ok prior to that limit. What exactly is your INSERT command? Hopefully it's a SQL Insert with that number of records.

The number of users and/or the number of insert could have changed causing the error to be more frequent.