cj92713696
Programmer
My problem :
I'm using the Data Environment with Visual Basic 6 connecting to an Access database. When my programs starts, it reads an *.ini file to determine where the respective *.mdb should reside. What I'm trying to do is to change the Data Environment to recognize the new location of where the *.ini file states the *.mdb should exist and use that new location for any database transactions. My Data Environment is called DE. I've tried to change my DE like this at the form_load event w/o any success.
de.conn.connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;C:\DB.MDB"
where C:\DB.MDB is just my example, this is whatever value the *.ini contains as to make it dynamic.
I appreciate any help!
Thanks,
CJ
I'm using the Data Environment with Visual Basic 6 connecting to an Access database. When my programs starts, it reads an *.ini file to determine where the respective *.mdb should reside. What I'm trying to do is to change the Data Environment to recognize the new location of where the *.ini file states the *.mdb should exist and use that new location for any database transactions. My Data Environment is called DE. I've tried to change my DE like this at the form_load event w/o any success.
de.conn.connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;C:\DB.MDB"
where C:\DB.MDB is just my example, this is whatever value the *.ini contains as to make it dynamic.
I appreciate any help!
Thanks,
CJ