Query Causes Access to Crash (1 Viewer)

[mikebaldam]

Hi,

I got quite a large SQl query that runs fine... but everytime I try to save it it just crashes instantly.

The query stores 22 temporary fields as experessions, but it works fine untill I try to save the changes I've made.

Any Ideas anyone...?

I've tried reinstalling it & repairing it. Virus checked my PC on-line with a couple of antivirus companies.....

Even If I try to rename an existing query it crashes out instantly.

Cheers

Mike

 

[llkhoutx]

Corrective actions which sometimes fix errors like yours:

a. Compile all the code in your program amd repair all errors.
b. Repair and compact your MDB.

 

[mikebaldam]

Yeah, I tried a few fixing progs but they didn't do anything (one just crashed instantly!).... But I've sussed it now...

Bad SQL was my problem - I was calling the same field twice in 2 difrerent Iif statements which was causing it to crash instantly.

Wierd ... but at least its working again now...

Thanks

Mike