Dynamicly Setting Data Environment Connection Objects.

[SQLwannabe]

I'm using Data Environment Connection Objects for use with my reports in my project. I cannot figure out how to set up the connection to the database dynamicly at run-time using something like app.path.

I'm very familiar with setting up a connection string with ADO objects, but DE objects have me stumped.

Thanks for any help,
Walter Cantrell

 

[tessanoel]

Walter-

This is what I used in VB-6 in the Data Environment Initialize:

Private Sub DataEnvironment_Initialize()
'Set moveable data connection
conProject1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.00;" & _
"Persist Security Info=False;Data Source=" & App.Path & _
"\Project1.mdb"
End Sub

Hope this helps.

Tessa