Creating SQL view

[Ranojay]

How do i create a "VIEW" in SQL in MS-ACCESS Databases ? Help!:confused:

[ChandraRam]

Ranojay wrote:

How do i create a "VIEW" in SQL in MS-ACCESS Databases ? Help! :confused:

They are in the "Queries" tab when you open the database within MS Access.

[samrat net]

Sorry friends!!!!!! The Microsoft Jet database engine does not support the use of CREATE VIEW, or any of the DDL statements, with non-Microsoft Jet database engine databases.