The relative capabilities of each are for you to explore, as John has said,
but the simplest explanation for your end-user is that a SQL Server View is analogous to an Access SELECT Query.
Access' action queries would be performed by stored procedures in MS-SQL.
Sent: Tuesday, September 20, 2016 10:30 AM
Subject: Re: [MS_AccessPros] a question of terminology
A View is a Query, but a Query is not a View. In other words, a Query is a subset of a View - you can do much more with a View. For example, a View can contain one or more Common Table Expressions (CTE) to simplify or enhance the result of the final query. You can't use a CTE in an Access query - you have to build a query on other queries.
Posted by: Steve Conklin <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|