Hi All,

Is there any way to create a connection with SQLConnect() that will then be used by future opened views that are set to share a connection?

I can open view after view, that will all share the same connection... but, I need to create the connection so I can run the sp_setapprole sp, and then have the views use that connection.

If anyone knows how to do this, or has another way, let me know!!!

BOb