ADO ConnectionString issues

[SiJP]

I've an AccessXP db connecting to an Access97 db using the following code:

        Set cn = New ADODB.Connection
            cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydb.mdb;Jet OLEDB:System Database=C:\mysec.mdw;"
            cn.Open , "myuser", "password"

The following message is returned when opening the connection (e.g. break point is cn.open):

-2147217843 Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

I've checked that the paths to both mdb and mdw files are correct, and the uid/pwd is fine. The MDW is used for all our databases, so I have had to use it to open the AccXP db.

Any ideas gyus?


------------------------
Hit any User to continue

 

[LonnieJohnson]

Would you have to have XP and 97 both installed on the same machine that is running the code? Just a thought...

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[SiJP]

Figured it out.. trailing vbcr's on the end of some variables in the connection string... (was using variables instead of string literals for the file paths..!)

------------------------
Hit any User to continue

 

[cmmrfrds]

I am surprised this worked on an Access 97 database.
Provider=Microsoft.Jet.OLEDB.4.0
My understanding was that Access 97 was Jet.OLEDB.3.5 format.

 

[SiJP]

True that acc97 is 3.51, but 4.0 is supported..

------------------------
Hit any User to continue

 

[ratsstar99]

use a udl file for ado connection purposes. it will save you a lot of time and hassel, you will find out how to make them on the microsoft web site or just look through google, its really worth your while and only takes a few seconds.