Re: reserved error -1524 access 2007

Tech-Archive recommends: Fix windows errors by optimizing your registry

The reserved error means something went wrong that the Access developers did not anticipate. It is difficult to guess what that might have been.

Not sure what to suggest other than compacting the database:
Office Button | Manage | Compact/Repair

You can try posting the SQL statement here if you wish, but it would be very difficult to trace what's going on without details of the field types.

If your regional settings are Spanish, I don't know what chararacter you use as the delimiter. It's defined in the Regional Options of the Windows Control Panel, and you may need to use that characters in place of the comma in the IIf() expressions. For example, if you use ; rather than , you might try:
IIf([A] = [B] ; 1 ; 0)
I've no idea whether that could help.

As always, you want to ensure Name AutoCorrect is turned off:
http://allenbrowne.com/bug-03.html

It might be that JET is getting the data types mixed up. If so, you might be able to explicitly typecast:
http://allenbrowne.com/ser-45.html

If you have yes/no fields and outer joins, it might be the result of JET's inability to handle nulls in logical fields
http://allenbrowne.com/bug-14.html

You could try switching the query to SQL View, and copying the statement out to Notepad. Delete the query. Make a new one, switch to SQL View, and paste the statement back.

Not sure any of that will help, as I would have expected the same issues under Access 2003. Perhaps someone else has another idea to contribute as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Elias Moreno" <Elias Moreno@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:97FD2C4F-631A-4F4B-94CB-379AD67E086A@xxxxxxxxxxxxxxxx
I'm using the evaluation version of Office 2007 pro. I have an application
that I was using seamlessly under access 2003 version. When I run it under
access 2007 I find that some queries fail to execute replying the message:

Error reservado (-1524); no hay ningún mensaje para este error.

of course I'm using the spanish version. as a clue, I found in both cases
the error raises in queries with embedded comparison functions (iif).

If somebody can help me I really appreciate.

.

Quantcast