I upgraded my access 97 database to access 2000. Unfortunately, my vb6 project was a victim of the switch. I upgraded my VB6 to SP3. I successfully switched the data controls to adodc and have one problem left. It pertains to the Date Environment.
I want to use the Microsoft OLE DB Provider for ODBC Drivers as a provider. The ConnectionSource is DSN=MS Access Database;DBQ=c:\pccomp\residuals.mdb; DefaultDir=app.path;DriverId=25; FIL=MS Access;MaxBufferSize=2048;PageTimeout=5 ;UID=admin;
When I press “Test Connection” it connects. Unfortunately, I want my users to be able to install my application on a different drive other than “C” so I must be able to refer to the drive by use of the app.path & “[database.mdb].
My previous version (using Jet 3.51) allowed the ConnectionString of
"Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "\residuals.mdb" & ";Mode=Read;Jet OLEDB:Database Password=479764818"
It worked perfectly, now I need to do the same thing for the ConnectionSource instead of the ConnectionString.
1.Can I modify the ConnectionSource string in the Properties window? In other words substitute something for the C:\PCComp directory with the app.path?
2.Can I assign the data environment at run time using source code?
This is my first post here so please help. Microsoft has nothing online or in their help files at all (surprise).