Sandeep wrote:
but I can n't access public synonym from add table but strange thing
that I
can access those public synonym from microsoft query , it returns
data too.

MS Query sends SQL it doesn't understand to the database server for
execution. Obviously the synonyms are known on the server side so it's
not so strange that the query returns data.

Jamie.

--