G
Guest
Yesterday I was running into a query bug. It's fixed (with no change to the
SQL, hence why I think it's a bug) and I'm not sure how I fixed it, if it
were me at all. I'm hoping that someone else had had the same "symptoms" so
they can tell me how they cured the problem. I just took shots in the dark
and somehow one of them worked (maybe).
I have a query that uses a cartesian join (if that has any bearing). The
query was basically a filtering query based partly on start and end dates.
That's where the cartesian join comes in -- I put the start and end dates in
a date lookup table. Oh, and the query was based on other queries, and some
of the underlying tables were linked (though all Access tables).
Anyway, things worked fine for a while, then just stopped. Here's what
happened next:
1) When I tried to design the query, it went straight into SQL text mode,
not GUI design.
2) When I tried to go into design mode, the db just closed. No warning, just
closed.
3) When I tried to run the query, I got the hourglass for a few seconds,
then nothing.
4) Compacting did not solve the problem
5) Opening the query took much longer than normal (and, as stated earlier,
went straight to SQL text mode).
6) After some messing around -- but no changing of the SQL text -- things
started to work.
Anyway, I'm hoping this will sound familiar to someone and that that someone
can tell me how to solve the issue in a more consistent manner.
Much thanks,
-Mark
SQL, hence why I think it's a bug) and I'm not sure how I fixed it, if it
were me at all. I'm hoping that someone else had had the same "symptoms" so
they can tell me how they cured the problem. I just took shots in the dark
and somehow one of them worked (maybe).
I have a query that uses a cartesian join (if that has any bearing). The
query was basically a filtering query based partly on start and end dates.
That's where the cartesian join comes in -- I put the start and end dates in
a date lookup table. Oh, and the query was based on other queries, and some
of the underlying tables were linked (though all Access tables).
Anyway, things worked fine for a while, then just stopped. Here's what
happened next:
1) When I tried to design the query, it went straight into SQL text mode,
not GUI design.
2) When I tried to go into design mode, the db just closed. No warning, just
closed.
3) When I tried to run the query, I got the hourglass for a few seconds,
then nothing.
4) Compacting did not solve the problem
5) Opening the query took much longer than normal (and, as stated earlier,
went straight to SQL text mode).
6) After some messing around -- but no changing of the SQL text -- things
started to work.
Anyway, I'm hoping this will sound familiar to someone and that that someone
can tell me how to solve the issue in a more consistent manner.
Much thanks,
-Mark