repost: MS-Query dosn't see my synonyms...

Please excuse this repost....
Stuck between the horns of a dilemma...

I was puttering around with Microsoft Query one day, and found that one of the tables that I see normally using SQL*Plus is not listed as a table in MS-Query and is inaccessible.

When I investigated using SQL*plus I found out that the table I asked for was in fact a synonym. But the table for which this synonym refers doesn't exist.

And when I looked using MS-Query for synonyms I couldnt see the synonym I wanted.

I checked out the FAQ but I couldn't seem to find an answer.

What can I do to see the synonym I'm looking for? Can I convert this orphaned synonym to a table? Should I not touch this at all?

• Mike Michael.Gold_at_france.ncr.com