Access quit after trying to save

  • Thread starter Thread starter NIck
  • Start date Start date
N

NIck

Very complected query based on 27 tables and don't ask way
I have been asking it for two months, I am basicly
consoldating all tables hopefully into on the problem is
that it has many experissions and I know about the
truncat, my problem is that the query used to run had to
ctrl, alt, and delete to end task since it was going on 2
hours of run time. After rebooting trying to design the
query access quit, trys to run it access2000 quits, run
other queries no problem. I have squzed my brain out to
resolve this with no vale I have tring VBA creating long
expression querydef no can do. Help :D
 
Very complected query based on 27 tables and don't ask way
I have been asking it for two months, I am basicly
consoldating all tables hopefully into on the problem is
that it has many experissions and I know about the
truncat, my problem is that the query used to run had to
ctrl, alt, and delete to end task since it was going on 2
hours of run time. After rebooting trying to design the
query access quit, trys to run it access2000 quits, run
other queries no problem. I have squzed my brain out to
resolve this with no vale I have tring VBA creating long
expression querydef no can do. Help :D
Click to expand...

We'd help if we could, but you've given us nothing to go on.

All I can suggest is that a) consolidating 27 tables into one is
almost certainly a Very Bad Idea; relational databases tend to have
many tables, not one; and b) storing many calculated fields in a table
is An Even Worse Idea. Are you sure you're even heading in the right
direction?
 
Back
Top