Refreshing a connection...

[Mario]

I am creating a new view dynamically in my SQL server
database. The connection does not see the new view, so I
cannot do a docmd.openview on it. How do I refresh the
connection so I can execute it? I need some kind of
connection refresh capability, right?

 

[Uwe Ricken]

Hi Mario,

the simpliest way is to create a form (datasheet mode) with
"SELECT * FROM myView" as recordsource.

If you open the form all meta data information will be requested
by access. Otherwise it is very complicated to refresh the containers
of Microsoft Access (ADP) because the object model does not
know the classes
- Container
- documents

This is a feature for JET-Databases only :-(

HTH ;-)

--
Gruß, Uwe Ricken
MCP for SQL Server 2000 Database Implementation

GNS GmbH, Frankfurt am Main
http://www.gns-online.de
http://www.memberadmin.de
http://www.conferenceadmin.de
____________________________________________________
APP: http://www.AccessProfiPool.de
dbdev: http://www.dbdev.org
FAQ: http://www.donkarl.com/AccessFAQ.htm