How to create a View in Access using Jet SQL?

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?
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a View in Access 2000 using Jet SQL? 5
How to create View in Access 2000 using Jet SQL? 5
Is there any detailed reference for Jet SQL? 1
From jet to t-sql 1
Connection string problems 2
Convert to ADO for SQL Server back end 4
Unable to import or linke SQL Server 2000 Ojbect but works in Exce 1
SQL Rules 22

Top