From: Rodrigo Santos on 23 Mar 2010 08:37
Is there any compatibility between the queries from Access and Sql Server?
Like I have a system that needs to migrate the database and the queries from
the source code, I can use DTS to migrate de database from Access to Sql
Server but what about the queries? Will Sql Server understand them or I'll
have to change it manually?
From: Mary Chipman [MSFT] on 23 Mar 2010 10:52
The answer is, it depends. Some query types are not supported, but
straightforward SELECT queries are essentially the same in Access-SQL
and Transact-SQL. However, if you use expressions, VBA functions, form
references or other Access features in your queries, then the answer
is no. The SQL Server engine has no way to evaluate those query
elements. Here are some resources that will help you.
Optimizing Microsoft Office Access Applications Linked to SQL Server
What are the main differences between Access and SQL Server?
Microsoft Access Developer's Guide to SQL Server (it's old, but still
valid except for the chapters on ADPs)
Access MVP Armen Stein has some free resources on his site:
In future, if you have any questions relating to Access as a front-end
to SQL Server, the Access newsgroups
(microsoft.public.access.externaldata, odbcclientsvr, or sqlupsizing)
will probably yield a wider range of responses.
On Tue, 23 Mar 2010 05:37:01 -0700, Rodrigo Santos
>Is there any compatibility between the queries from Access and Sql Server?
>Like I have a system that needs to migrate the database and the queries from
>the source code, I can use DTS to migrate de database from Access to Sql
>Server but what about the queries? Will Sql Server understand them or I'll
>have to change it manually?
Prev: what is the boot record of the database file? & TDE
Next: Help With PIVOT - Please