How to create a View in Access using Jet SQL?

  • Thread starter Thread starter lu_yanfeng
  • Start date Start date
L

lu_yanfeng

Can any body tell me how to create a View in Access using Jet SQL? And where
to get the detailed specific reference for Jet SQL?
 
IIRC, JET 4 accepts the CREATE VIEW syntax but I haven't seen anyone using
this to create a Query (i.e. Access View) in Access. Most Access developers
would use a saved Query or an SQL String or use DAO to create a saved (or
temporary QueryDef).

OTOH, if you are talking about SQL Server View from an MDB file, you can run
a Pass-Through Query to create an SSQL Server View. Alternatively, I am
sure (but not tested) you can use the Execute Method of the Connection
object to create a SQL Server View.

I don't use ADP but sine you can create View using the GUI, it must be
possible to create View by code also.
 
Back
Top