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

Possible it may be an index problem.