I can embed a 18 MB Word document in an Access 2002 OLE field without error, but a 35MB document returns the following error when I try to open it. "There isn't enough memory to complete the automation object operation on the OLE Object." I can actually get the file in the database table, and open it once if I don't leave the field. If I leave the field and go back and try to open it I get the error message. Microsoft indicates the field size limitation of an OLE field should be 1GB.
I'm doing this directly in the table to eliminate the user interface as the problem. I can also reproduce the problem in a new database with only one table with an OLE field. I can also reproduce the problem with my computer in safe mode. The problem was brought to my attention by a customer, so it's happening on their system using the 2002 versions of MS Access runtime as well.
I've increased my page file size, and I'm on a new Dell XPS 1730 with massive amounts of resources in terms of hard drive, memory, and processor speed, so it doesn't make sense that it is an issue with the computer.
Anyone have any ideas where to look?