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.
