<div>
a. Make sure the DB compiles.<br />
<br />
b. Open the query in design view, try executing, and see if your prompted for anything.<br />
<br />
Jim.
</div>


<div>
You might need to reinstall Office. &nbsp;Having &nbsp;64-bit Windows with 32-bit Office isn't a problem but I've always avoided upgrading Windows because of all the moving parts. &nbsp;I just wait until I get a new computer unless there is something urgent. &nbsp;<br />
<br />
Going from 32-bit Windows to 64-bit is somewhat of a surprise since Windows would tend to be tied to the hardware and the hardware must have started out as 64-bit since that couldn't change without replacing the motherboard so I don't understand why 32-bit windows was ever installed.
</div>


<div>
&lt;&lt;System resource exceeded&gt;&gt;<br />
<br />
&nbsp;With this error, there are any number of things that can trigger this. &nbsp;However with this:<br />
<br />
&lt;&lt;Query is too complex&gt;&gt;<br />
<br />
&nbsp;It's usually a reference/compile problem. &nbsp; But to cover all the bases:<br />
<br />
1. One thing that might have been done under the old OS is that the MaxLocksPerFile may have been set to a higher value. &nbsp; In your app, add the line:<br />
<br />
&nbsp;DAO.DBEngine.SetOption dbmaxlocksperfile,200000<br />
<br />
&nbsp;You can also do this in the immediate (debug) window.<br />
<br />
2. The other thing I would check is that the environment variables TEMP and/or TMP point to a valid drive/directory and that there is plenty of free disk space there. &nbsp; Open a command prompt and type SET followed by a return to see where they are pointing.<br />
<br />
3. Make sure you DB is not approaching the 2GB limit. &nbsp;Do a compact and repair on it.<br />
<br />
4. Last, try turning off any anti-virus product. &nbsp; You may be getting some inference there.<br />
<br />
Jim.
</div>


<div>
Jim: What are the steps to compiling the DB? Sorry if obvious, I never do this.<br />
<br />
To your other post:<br />
<br />
1. I tried to add DAO.DBEngine.SetOption dbmaxlocksperfile,200000 before the line of code that produces the error, but the error still occurs.... &quot;system resource exceeded&quot;.<br />
<br />
2. No issues with TEMP/TMP directories (plenty of space as well).<br />
<br />
3. DB is only 2.5MB (after repair and compact).<br />
<br />
4. Haven't installed any Anti-Virus. This is a fresh install of Windows 7 Home 64-bit. &nbsp;Note: did first big chunk of Windows Updates last night. It did not help any of the issues.<br />
<br />
Additional information, not only did this DB work on my Windows 7 32-bit (same computer) it also works fine (currently) on my Windows 7 Pro 64-bit pro at work! Only difference is I'm using MS Office 2010 (32-bit I think) at work (not MS Office 2007). So.. I may look into getting MS Office 2010 here.<br />
<br />
PatHartman: I don't feel like reinstalling will do anything since this is literally a fresh install of MS Office and MS Windows. <br />
<br />
Gustav Brock: Since it works on the other (almost same) systems, I'm not interested in reworking the queries but getting it to work on my home computer.<br />
<br />
Thanks,<br />
Chris
</div>


<div>
&lt;&lt;Jim: What are the steps to compiling the DB? Sorry if obvious, I never do this.&gt;&gt;<br />
<br />
&nbsp;Open DB with shift key held down.<br />
<br />
&nbsp;Wait till you see the Database window.<br />
<br />
&nbsp;Key Alt/F11 to bring up the VBA editor.<br />
<br />
&nbsp;Click on &quot;Debug&quot; on the menu bar and then &quot;Compile&quot; &nbsp;it should do this without error.<br />
<br />
&lt;&lt;Gustav Brock: Since it works on the other (almost same) systems, I'm not interested in reworking the queries but getting it to work on my home computer.&gt;&gt;<br />
<br />
&nbsp;This may be your only option if the compile works. &nbsp;Access has some internal limits that float a bit based on what's going on. &nbsp; From version to version it works a bit differently in each.<br />
<br />
In the past, queries needed to &quot;compile&quot; into a single 64K memory segment or you got &quot;Query too complex&quot;. &nbsp;Microsoft lifted that limit, but they never said to what.<br />
<br />
My guess is that Access has an internal memory heap it uses for various tasks and when it run's out, it's &quot;System resources exceeded&quot;.<br />
<br />
&nbsp;Another limit like this is the table ID's. &nbsp; The spec states it's 2048, and yet sometimes you can open more and sometimes you cannot. &nbsp; This is another limit that seems to float a bit as one minute a query will run, and the next not when your right on the border.<br />
<br />
&nbsp;It is entirely possible that you were right on the border with this, and moving to a 64 bit OS is pushing it over the limit because Access is working with the OS differently. &nbsp; Likewise it works in 2010 just because 2010 works a bit differently.<br />
<br />
Jim.
</div>


<div>
<blockquote>
Since it works on the other (almost same) systems, I'm not interested in reworking the queries but getting it to work on my home computer.
</blockquote>
<br />
Well, yes, we are all lazy, but if it turns out as the only option? <br />
Why not check out just one query? It may be nothing more than switching to SQL view, edit back and forth, and run again to rebuild the query optimizer.<br />
<br />
/gustav
</div>


<div>
Jim: I clicked compile, nothing really happened, and then the option was grayed out after. Not sure if that's expected or not.<br />
<br />
What I'm probably going to try next is Access 2010, since that's what I'm using at work.<br />
<br />
Gustav: I did try removing one of the joins to see what would happen and no longer got the &quot;System resources exceeded&quot;, but I just don't know how to trim my joins down at this time so I'll have to &quot;table&quot; this for now. I'm still able to use the program by VPN'ing to my work computer at least.
</div>


<div>
&lt;&lt;Jim: I clicked compile, nothing really happened, and then the option was grayed out after. Not sure if that's expected or not.&gt;&gt;<br />
<br />
&nbsp;That means it compiled with no errors.<br />
<br />
Jim.
</div>


<div>
OK. What happens if you add the join back?<br />
<br />
/gustav
</div>


<div>
Same issue if I add the join back.
</div>


<div>
Alias the table names. &nbsp; Right click on the tables, select properties, and rename them to something short like &quot;H1&quot;, &quot;D1&quot;, etc.<br />
<br />
That may get you in under the limit.<br />
<br />
and curious, how many tables, joins, and fields are we talking about? &nbsp;<br />
<br />
Jim.
</div>


<div>
Isn't that what I suggested you do?
</div>


<div>
He didn't reinstall; he installed a different version of Office and that really wasn't a &quot;fix&quot; either, but more of a work around.<br />
<br />
Jim.
</div>


<div>
OK I modified my solutions here. Gustav, since reworking the queries was the technical solution (that I was unable to achieve at this time) and mine was the work around that worked for me.
</div>


<div>
<div class="content wysiwyg-content">
My MS Access database worked on Windows 7 32-bit. Then I installed Windows 7 64-bit and I get these messages in different parts of my database. Using Access 2007 (x86):<br />
<br />
System resource exceeded<br />
Query is too complex<br />
<br />
The only other change I did was added 4 GB of RAM.<br />
<br />
Really frustrating!
</div>
</div>


My MS Access database worked on Windows 7 32-bit. Then I installed Windows 7 64-bit and I get these messages in different parts of my database. Using Access 2007 (x86):

System resource exceeded
Query is too complex

The only other change I did was added 4 GB of RAM.

Really frustrating!

System resource exceeded and Query is too complex in Access 2007 after installing Windows 7 64-bit

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.