OLEDB/ADODB Problem

[Maritza]

I’m absolutely perplex, I'm using the following strings and commands to establish a connection and get recordsets;

strCon = "provider = Microsoft.jet.OLEDB.4.0;Data Source="
strDBName = CurrentDB.name
set cnx1 = new adodb.connection
cnx1.open strCon & strDBName


I also tried the following:

dim strCon as string
strCon = strCon2 = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=DevTest97;" & _
"DefaultDir=C:\Development\GSchedule\LatestVersion;" & _
"UID=Admin;PWD=;"

this code works fine in my labtop, which has the same exact software as my standalone, but I get the following error on the standalone;
Run-time error -2147467259(80004005)
Could not use ";file already in use

Nobody else is using the DB, the DB's default Opens Shared, and the directories are set exactly the same.

Does anyone knows what it's going on? Why I'm I getting the error message?How can I solved this problem.

Thanks,
Maritza

 

[Maritza]

the first strCon = is a typo, the strings stars

strCon2 = "......."