Error -1524

[LarsM]

I got the message "Reserved error (-1524); there is no message for this error".

Background: I have a database system with several identically structured
back end databases, each with data for one plant. From my front end database
I look at only one back end database at a time. In each back end database I
had until recently a table defining templates / standards of that plant. In
order to standardize the templates across plants I recently moved that table
from one of the back end databases to the front end database and deleted it
in all back end databases.

The problem occurs in a rather complex selection query where I (among a lot
of other relations) have a left join from a table still located in the back
end to the table I moved to the front end. In order to test if the problem
had anything to do with this fact, I deleted the reference to that table in
the query, but the problem still occurs. Does anyone have a good idea?

Regards; LarsM

 

[Daryl S]

Lars -

Moving a table from back-end to front-end shouldn't cause an error (assuming
the name is the same, and the linked table was removed). Maybe there is
another issue. You said this is a pretty complex select query. I would
recommend making a copy of this query to play with, and selectively removing
one source table/query at a time until you find which one is causing the
error. If it is a query, then make a copy of this query and repeat the
process.

If you find where the error is, but can't figure out how to fix it, reply
with the details you have found, and maybe we can help.