Avatar of dinmatt
dinmattFlag for United States of America asked on

Out of Memory error in 64bit Access 2010

I am running Windows 7 64bit and Office 2010 64bit. i have an Access application that when opened, displays an error that i have to add ptrsafe to some declarations. I ran through and added this to every area of code that came up as needing this. Now when i open the database, i immediately get an Out of Memory error. I have tried decompiling, compacting and compiling. nothing gets rid of this. anyone know how to resolve this?
thanks!
Microsoft Access

Avatar of undefined
Last Comment
dinmatt

8/22/2022 - Mon
Nummmnut

How big is your Access Database?

I think the limit is like 2 GB.
ASKER
dinmatt

its like 24mb.the problem only occurs in the 64bit. workstation.  as an update i installed SP1 of office 2010 and i got farther in that the database opened and compiled with the error but the minute i tried to attach to an mde i use to run reports, it gave me the out of memory error again and seems to have toasted the whole database now. grrr.....
Nummmnut

How much RAM do you have in the system?

Also verify your paging has not been changes...

(Just covering the basics)
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Nummmnut

Have you done a Compact and Repair?

Also 23 MB is include all your tables and reference databases?
Scott McDaniel (EE MVE )

Have you checked the References on the 64-bit machine? To do that, open your database, open the VBA Editor and click Tools - References. Are any marked as MISSING? If so, you'll have to resolve that before proceeding. If you'd list the References you have, we can review them and perhaps give advice.

Are you using ANY ActiveX controls in the database (like a Calendar control, for example)? If so, then you'll have to remove that if you stay with the 64-bit Office versions (or upgrade to the 64-bit version of the control, and there are very, very few of those currently available).

What's the reason for using the 64-bit version of Office? Most developers (and Microsoft) recommend using the 32-bit versions unless you have a definite need for features in the 64-bit versions. Apps developed on the 64-bit platform can ONLY be used by others running the 64-bit version of Office.
ASKER
dinmatt

I have 4GB RAM. the front end is about 24-43mb and there are 2 backend databases. I am using samples for now and they are only aboutr 10mb apiece. I connect to an mde database as well to run reports. this database is about 14mb.

I do use comctl32.ocx which I am beginning to suspect may be all or at least part of the problem.

I do not prefer to use 64bit but have 2 clients so far that have decided to go 64bit and now are having problems running my application. I would prefer to deal only with 32bit but i am trying to find a solution that will allow them to run my 32 bit application on their 64bit systems. thank you!!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Scott McDaniel (EE MVE )

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
dinmatt

thanks for the info. That confirms what I have been reading as well. Do you know if there is a way to have it run in something like a windows xp or 32 bit compatibility mode? Or does microsoft have an alternate control that can be used for treeview?  Just looking for work arounds. I use comctrl32.ocx for the treeview for creating an inventory assembly tree.