Access sql server not updating tables
Views can be used in place of tables in your Access front-end application, whether you're using an Access database or an Access project.
Views can also reference functions and other views.
Another limitation of views that you may be familiar with is that a view cannot be indexed. In SQL Server 2000, you can indeed create indexed views, as shown later in this chapter.
When a user selects data from the view, only the result set is passed over the network—all of the joins and aggregations are performed on the server, not on the client. Then grant appropriate permissions on the views for the users and roles you want to be able to access the data.
Views can also be used to hide the real column names or underlying schema of your tables.
To return the top 10 customers or the top 10% of customers, based on sales over the past year, SQL Server needs to sort customers by sales.
So, a view that returns the top 100% by sales would essentially be a sorted view.
You can create a DSN file directly by using the Data Connection Manager.