How to make views visible in Access?

[Laser Lu]

I created views by using the "Create View" statement in the connection of
ADO. And, however, I can not see them in the Access, even after I have shown
hidden objects in options dialog.
So I wonder how to make those views created by SQL visible in Access?

 

[Laser Lu]

I encountered this problem in Access2000.

 

[Laser Lu]

Actually, you could use "create view" syntax in the code of ADO(ActiveX Data
Objects) when connecting to a Access database, though View can not be
created in Access expect for an alternative as Query. And the Views that are
created in the ADO code can be accessed in the code of ADOX(Extension for
ADO, by which you can manipulate schema objects in the form of code), but
they can not be visible in the Access GUI.

 

[Douglas J. Steele]

AFAIK, it's not possible.

http://support.microsoft.com/?id=246213 talks about how views created
through ADOX aren't visible because "Microsoft Access 2000 does not expose
the interface that makes these views visible or available outside of its
form level". I think the same is true of views created through ADO.

 

[Laser Lu]

Thank you very much, Doug Steele!

 

[david epsom dot com dot au]

So I wonder how to make those views created by SQL visible in Access?

I don't think it is possible in Access 2000.

You can use DAO to create QueryDefs that are visible in
Access 2000.

(david)