Reserved error (-1524)

[KrispyData]

I have Access 2007. I am running a query created in an Access 2000 (mdb
file) database. This query is pulling results from multiple queries. I get
this "Reserved error (-1524)" and when I click on Help it simply states
"there is no message for this error. (Error 3000)" I'm not sure how I should
start troubleshooting for this error. Would you have any suggestions?

Thank you!

 

[KrispyData]

Hi RuralGuy,

I just ran each of the subqueries. Yes, they all run by themselves.

The query I am running is based on a dozen queries with a left join to one
query.
In other words,
Query1 LEFT JOIN to Query2, Query3, Query4, Query5, etc....

Could it be an issue with the joins?

 

[Tony Toews [MVP]]

I have Access 2007. I am running a query created in an Access 2000 (mdb
file) database. This query is pulling results from multiple queries. I get
this "Reserved error (-1524)" and when I click on Help it simply states
"there is no message for this error. (Error 3000)" I'm not sure how I should
start troubleshooting for this error. Would you have any suggestions?

Can you open the query in design view and then try saving it?

Tony

 

[Philip Herlihy]

Can you open the query in design view and then try saving it?

Tony

Oops - wrong group. This is for the Access database.
But see: http://mail.google.com/support/bin/answer.py?hl=en&answer=86382

Phil, London

 

[Philip Herlihy]

Oops - wrong group. This is for the Access database.
But see: http://mail.google.com/support/bin/answer.py?hl=en&answer=86382

Phil, London

Silly me. I was trying to reply to an enquiry here about gmail. Bit of
a non-sequitur in this context!

Phil