HI,
I created a connection to an Access database. While I can create a remote view without any problem (even the table name has a blank) , I do have some problem with the syntax. I need to query the view like this

SELECT MyRemoteVIew."My Field" from MyRemoteView where anotherfield = "some value"

I get the message : "Syntax error". And when I try :
SELECT "My Field" from MyRemoteViewo where anotherfield = "some value", I get several records that has "My Field" as a value (tge same occurs when I use [My Filed].

I know that with ADO I can resolve the problem with [My Table].[My Field].

Anybody has done something similar ?

Thank you,
Christian Cote