My access database crashes when I run a query

J

j

I run a multi-query process with VBA in access - it completely crashes MS
Access when I run the process. The query that it crashes on runs fine by
itself, and it doesn't even give me an error, it just shuts access down
totally- and offers to send an error report to MS.

Anyone experience this? I can post the code, but I'm not sure how that will
help (there is a TON, and it simply inserts queries into a list and runs it).

Thanks,
Jesse
 
K

Ken Snell [MVP]

I know that there is a bug in ACCESS for multiple-nested queries, especially
if they use Union queries. I've had some communication with MS about this
via Product Support, but to my knowledge there is no fix yet.

Your only recourse will be to rewrite the query to avoid the problem (may be
difficult if you're not sure what is causing the problem), or to use
programming to generate intermediate recordsets on which you build more
filters and/or queries.
 
G

Gary Walter

Since June Windows Updates,
my Access XP, Windows XP Pro
machine has been doing this
pretty regularly.....
I am switching over to my Access 2000,
Windows 2000 Pro machine to develop
until somebody gets their act together.

I sent all the errors at first, but sheesh!!!

gary
 
J

j

Great. Frustrating thing is, it's been working for nearly 3 years. I
changed some lookup tables that were mapped to a drive in the VBA, to find
them explicitly on my network - and everything is haywire now. I'm trying to
get my data center to give me a copy of the db from a couple weeks ago (when
everything was working fine). I REALLY don't want re-write this (a massive
interface between Peoplesoft and some recruiting software) but I think the
time has come to move this process to something that can handle things
better. :(
 
G

Gary Walter

I have found what I believe was *my problem.*

I work on db's at home (Access XP, Windows XP Pro)
that are used at work (Access 2000, Windows 2000 Pro).

All systems have "latest and greatest" SP's, SR's, etc., updates.

Somewhere in the process of bringing a copy of a db
home, I am randomly losing "Me!" before a reference
to a form control in my code.

I make some changes to code, save, then compile,
and my XP system does not complain about the
missing "Me!"..... but it crashes Access....
even though I write all of my code with error
handlers.

So...in my case only, when Access has crashed,
I go into code and sure enough there is one or
more references to a form control that is missing
the "Me!" in front of it. I make change, and all
is well (until next time).

Maybe that will help someone....
(maybe that is already documented somewhere).

gary
 
Top