Server = SQL Server 2000 SP3a
Client = Access 2000 SP3 data project

I have a button on a form which when clicked creates a view based on the
users selections, then opens a report who's recordsource is the newly created
view.  

The name of the view contains the username, so its specific.  The problem is
when the report opens it fails with:
"The record source 'vw_myusername_report' specified on this form or report
does not exist"
I think the reason is because the database window has not been refreshed,
the access client cannot see the newly created view.  If I press F5 when
looking at the Views section of the database window, this refreshed it to
show the new view, and then the report works fine.

I can't predict who will be using the system, so would like for it to be
seemless, so I tried adding into the onOpen of the report
Application.RefreshDatabaseWindow
I  also tried adding that to the docmd.openreport() on the onClick on the
button on the form, bu no joy.  It does not refresh the window.  But F5
works.  But I do not want the database window to be visible to the user, and
it should be automatic.

Anyone else come accross this, or would have some suggestions  as to how to
proceed?

Many thanks for any suggestions!