editing query with functions gives app error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a query with a function which works when it runs but I can't view it in design mode anymore. Everytime I do, it crashes access. I tried converting to 2002 and 97 (worked before with similar problems) and then back again but still no luck. Is there anyway to work this out? I would just like to get the SQL and recreate it differently.

Debug error:
CiceroUIWndFrame:MSACCESS.EXE - Application Error
The instruction at "0x002c0022" referenced memory at "0x00000000". the memory could not be "read".

Please help, I am desparate.

thanks,
Zachary
 
Perhaps you can get it by using the debug window to print the sql statement out.
Don't know if this will work for sure, but...

In the debug window, enter something like the following and then hit return.
That should write the sql statement in the immediate pane. You can copy that
and paste it into the SQL window of a new query.
?CurrentDB().QueryDefs("Yourqueryname").SQL

I suspect that your database is corrupted. I would try opening a new database
and then copying all the objects over into it (with the exception of your "bad"
query).

Hope this helps
 
Back
Top