Users have been getting "There isn't enough memory to perform this operation" error messages in an Access 2003 .mdb database. I've found some corrupt objects and replaced them, but they're still getting this error. I finally pinpointed a set of circumstances that causes this. If the following 2 things are done in this order, the error occurs ...
1.) The "DoCmd.FindRecord" command is used on any form (no matter how complex or simple the form is)
2.) The user finds a record on a specific form that is bound to a query that is based on a SQL Server linked table that has 40 fields, one of which is a varchar(MAX) field, and that has criteria such that the query outputs 233 records.
Does anyone know if this is a known bug? How can I find out if this is a known bug and if there is a hot fix for this? Does anyone have any suggestions about a workaround?