ADP creates views and functions instead of stored procedures

[qwertyjjj]

Just been upsizing an Access DB.
It seems to create views and functions for normal select statements and stored procedures are only created for insert or update statements.
As fas as a recent DBA told me, he said that views should be used sparingly as they are not very efficient. Is this the case?
I also don't see why you would create a function when you could use a stored procedure to so the same SELECT statement(s) ?

 

[boblarson]

A View IS a SELECT statement. A Stored Procedure can be used in place of a view, and if the view would be of a very large dataset, a Stored Procedure could be more efficient. However, in the size of data that most people are using with Access, it really wouldn't be that discernable as to which was being used.

The Access upgrade wizards do upgrade normal Select queries to Views and Action queries to Stored Procedures. You can go create your own SP's and change the recordsources to point to them instead of the views, if you wish.