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? (I met
this problem in Access2000.)

 

[Allen Browne]

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.

 

[Laser Lu]

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?

 

[Allen Browne]

Yes. They should show. It may take a RefreshDatabaseWindow.

 

[Laser Lu]

Is RefreshDatabaseWindow an interface or function in DAO?

 

[Allen Browne]

Is RefreshDatabaseWindow an interface or function in DAO?

Does this question deserve a RTFM?

 

[Laser Lu]

No, I just wonder if it is an operation in Access or the function that can
be invoked in the programming code?