Am trying to connect to an Access 2000 database using Jet 4.0
the access database is protected by a mdw file
So I enter the user name and password
then when I push the Test connection it comes up with
"Test connection failed because of error in initializing provider. %1"
Have checked the Microsoft site and they have no info on it.
Have also checked the connection with a non protected database (changed the mdw file in wrkgadm)
It worked fine
Have checked the user name and password no problem there.
I was thinking it might have something to do with telling the DataEnvironment where to look for the mdw file
Any one have a similar problem and have a fix for it?
the access database is protected by a mdw file
So I enter the user name and password
then when I push the Test connection it comes up with
"Test connection failed because of error in initializing provider. %1"
Have checked the Microsoft site and they have no info on it.
Have also checked the connection with a non protected database (changed the mdw file in wrkgadm)
It worked fine
Have checked the user name and password no problem there.
I was thinking it might have something to do with telling the DataEnvironment where to look for the mdw file
Any one have a similar problem and have a fix for it?