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.
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.