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

Using IF logic in a calculated field 2
Office 365 Outlook adding unwanted HTML to Email Body 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Connection string problems 2
maximum number of indexes per SQL table that Access (jet) can dealwith? 0
Help creating a search form in Access XP 0
MS says that all tables should live in SQL (for performance reasons) 12
HOW do I ' create function ' ???? ' cannot change object type in ascript ' ???? 8

Top