Link to home
Start Free TrialLog in
Avatar of zachvaldez
zachvaldezFlag for United States of America

asked on

programming sql queries in Access

Is it possible to program SQL queries in Access with the "dbo_ xxxxxx" scheme?
Would the underscores cause an error?
SOLUTION
Avatar of jerryb30
jerryb30
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Scott McDaniel (EE MVE )
Note that those queries must use ACCESS syntax, and not SQL Server Syntax. You can use "pass through" queries to do this - pass through queries are defined in Access, but you also define a connection string to your SQL database. The Access database then "passes through" your query to the sql server without parsing.
Avatar of zachvaldez

ASKER

can you provide examples please?
Id like to repharse the question?
"How can I program SQL queries in MS Access with the "dbo_tablename" schema used in SQL server?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It is an OK answer but thanks for your help
Well it was not really an answer, just a request for more info.

Is this issue now resolved?
If so, what was the actual solution?