How to make views visible in Access?

  • Thread starter Thread starter Laser Lu
  • Start date Start date
L

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? (I met
this problem in Access2000.)
 
They should show on the Queries tab of the Database window after:
RefreshDatabaseWindow

If they are still not there, see if you can find them listed in the
QueryDefs:
? CurrentDb().QueryDefs("YourViewNameHer").SQL

In ADOX, they are in the Tables of the Catalog, distinguished by the Type
property.
 
Thank you, though I'm not familiar with DAO. And actually, in ADOX, they
will be both in Tables and Views of Catalog.
However, my question is whether those Views can be shown right in the Access
GUI?
 
No, I just wonder if it is an operation in Access or the function that can
be invoked in the programming code?
 
Back
Top