Query by Form help

[th3spankst3r]

Hey everyone. Sorry I'm asking so many questions, but hopefully this one will be an easier fix. I'm trying to do a Query By Form (QBF) according to the QBF instructions found here:

http://support.microsoft.com/kb/209645/

When I applied my personal object names to this technique, it worked at first, until I saved, closed, and reopened the database. Now, when the query is ran or I try to open it in design view, it gives me an error:

There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.

I am running a fairly new machine with no excess programs in the background, have tried it on multiple machines too.

I have tried compressing/repairing

I have tried deleting and rewriting (which worked only temporarily again)

I have called Microsoft, but they no longer support Access 2000.

I have searched forums, and supposedly there's a patch out there somewhere that I cannot seem to find, but regardless, this database will be on a shared network drive so that multiple computers will be able to access it. If I use a patch, I will have to install the patch on all of the machines accessing the database, and I don't have access to all of those machines, because I am not the network administrator.

I have also searched Microsoft's website, and put in a trouble ticket, however they referred me to the customer support line who told me to kick rocks.

Has anyone else encountered this sort of problem? Is there a solution?

 

[formerTexan]

Probably no definitive answer, but:

How big of a memory footprint is the application creating when the error raises?
Is your code compiled?
Have you tried creating a new db and importing everything except the offending queries and forms? Recreate those.

Cheers, Bill