Visual Basic Concepts

Accessing SQL Views Using DAO

If the remote database only exposes SQL views, you can access this data by attaching those views to a Jet database and creating pseudo indexes to the view using a DAO action query. Although not actually an index, a pseudo index allows Jet to create an updatable recordset on the view. You don’t need to create a pseudo index if you are not updating server data.

SQL views can also be accessed by DAO through ODBCDirect. In some cases these views are updatable using the indexes already available on the remote server.