Stored procedures vs. views for filling record sources

  • Thread starter Thread starter Andy G
  • Start date Start date
That depends on your requirements.

A stored procedure is generally more secure, and will perform better because
of caching etc, but a view can be selected from (e.g. SELECT SomeCol FROM
SomeView). You can also use UDF's which are cached like sp's, but can be
selected from.

Views do not support parameters, sp's and UDFs do.

Depening on requirements, I often use Views for updateable recordsets
because they are normally easier to bind and modify etc, but for read-only
recordsets I normally try to use SP's.

Outside of Access, where updates/inserts etc have to be written I always
prefer to use SP's.
 
Technically; ADP -- as in Access Data Projects allow you to do anythign
you want with sprocs.

they are a lot more powerful than MDB for using sprocs.

-Aaron
 
Back
Top