Modules Failing Intermittently

[JDCliff]

Running Access 97.&nbsp;&nbsp;DoCmd.Openquery &quot;some query name&quot; is failing with an error message 7478 &quot;Couldn't find object&quot;&nbsp;&nbsp;The query does exist and it is spelled correctly.&nbsp;&nbsp;This line of code fails intermittently.&nbsp;&nbsp;The failure seems to be centered around the amount of rows in my tables.&nbsp;&nbsp;Some of my tables have 100,000's or rows.&nbsp;&nbsp;If I reduce the amount of data my modules all run correctly.<br><br>It strikes me that this is a pointer problem or something related because the error occurs when the rows increase.&nbsp;&nbsp;Does access have memory management problems associated with huge volumes of data?&nbsp;&nbsp;Has anyone come across a solution to this?<br><br>Thanks for any help - Jim

 

[DougP]

Perhaps, but it may be your computer is running out of Memory. How much do you have???? And How much Free Disk Space?<br>Try increasing the size of your paging file.<br>But when your outta of RAM your outta Luck!!<br>Access, &quot;She's a memory Hog all buy her self Captain.<br>You Need more Power Scotty!!!<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.