Storing a query in an existing database

  • Thread starter Thread starter Tor Inge Rislaa
  • Start date Start date
T

Tor Inge Rislaa

Storing a query in an existing database

Is it possible to create a query in an existing database (by code), by the
meaning that the query is named as a view and I can refer to it (Select *
From myQuery)

For a Table I would type: Create Table tblMyNewTable (FirstName TEXT,
LastName TEXT, Salary DOUBLE)


What would the syntax for creating a query be?

TIRislaa
 
Typically you use DAO / ADO to do this, but you can check the DDL help to
see if this is possible. I don't think it is.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
[MVP] S.Clark said:
Typically you use DAO / ADO to do this, but you can check the DDL help to
see if this is possible. I don't think it is.
Click to expand...
Access 97 has no views, and no DDL supporting them.
 
Back
Top