Hi All!
I have something really weird going on. I have an Access application that was written originally in Access 2003. I am trying to upgrade it to Access 2010.
All I did initially was update the file format to accdb. Most of the data is stored in SQL Server 2012 but we do have some local tables for processing purposes.
Before I go into the ins and outs here, let me first state that I was running Windows 7 Professional 64Bit, with Access 2010 64 bit.
When I ran the application, which ran fine under Access 2003, I had some code that just died. I posted a message here on it but I was basically getting a connection error on a RecordSet using the currentproject.connection.
On a hunch, I built a VM using 32bit Windows 7 Pro and 32 Bit office. Everything ran fine.
Finally, I create yet another VM with 64bit Windows 7 Pro and 32 Bit office and I get a memory error (There is not enough memory to perform this operation). Trust me when I say there is absolutely nothing else running application wise and the VM has 4GB total RAM for it.
It's the same codebase all around.
Needless to say I am kind of stumped here. Anyone have any ideas?
Thanks in advance!