Can Data Environment connection be changed in code

[Toby1kenobe]

Hi all

I'm using Data environment to bind my front end to .mdb. I'm concerned that if i use the DE that i wont be able to add a routine that lets the user select a new (or find) data file. Can the Data Environment connection be changed in code?

If so i don't need to worry
Thanks in advance

Toby

 

[bosully]

Yes, I've done this before.

Naturally you must have some connection specified using the Data Environment interface when developing and compiling your app but you can change the connection dynamically by editing the connection string as follows -

DataEnvironment1.Connection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=C:\Database.mdb"

- before you use the Open command.

Brendan