CODEWITHSUNDEEP
ms-access
Janis Peisenieks
Janis Peisenieks

Reputation: 4998

Is it possible to create a view in Access 2010?

As the title states - can it be done? I read on a MSDN page that this is not supported, but my assignment request for how. Can, and how can, it be done?

Upvotes: 4

Views: 24037

Answers (1)

David-W-Fenton
David-W-Fenton

Reputation: 23067

A view is nothing more than a saved SQL SELECT statement. This is what a saved query in Access is (though you can save DML SQL statements, too, of course).

In interactive Access, use the query designer to create any SELECT statement, save it, and you've created a view.

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

Upvotes: 6

Related Questions