On page 228 of "SQL Server Development with Access 2000", Rick Dobson 

points out that views created programmatically are not immediately 

accessable to the application.  The user must first open the database 

window and perform a manual refresh.  The RefreshDatabaseWindow command 

does not work for Views created within Microsoft Access projects.



Does anyone have a programmatic solution to this problem.  I do not wish 

application users to have access the database window, but it is necessary 

to use program-created views to provide different cross sections of the 

database.