Pass-through query causing an error

[PaulSpell]

I have a VERY simple select statement that I am using in a pass-through query: "SELECT * FROM dbo_vReturn;", but I cannot get this to work. Each time I run the query it generates an error: "ODBC call failed - Invalid object name "dbo_vReturn" (#208)".

The dbo_vRteturn is a view in the backend. I can open this table/view from Access using an ODBC connection but when I try to run the pass-through query it falls over!

Does anyone have any idea what is causing this?

 

[FoFa]

Try using dbo.vReturn instead

 

[PaulSpell]

FoFa, spot on, well done!

I see what's happenned now. Access obviously doesn't like the "." and replaces it with a "_" to concatenate the "dbo" to the object name, presumably to denote that it is a linked database object?

Anyway, it is working now so thanks very much.