Can I create a view in Access 2010?

Question

As the title says - can this be done? I read on the MSDN page that this is not supported, but my appointment request. Maybe, and how can this be done?

Answer 1

A view is nothing more than a stored SQL SELECT statement. This is what a saved query is in Access (although you can also save DML SQL queries, of course).

In interactive access, use the query designer to create any SELECT statement, save it, and you have created the view.

If you want to do this in code, it's pretty easy to find the code for it using either DDL SQL or DAO.