Unable to connect to any secured access database

[Lxmm]

I'm having a problem with VB.NET and Access 2000 database. I cannot seem to connect to database if it has a database password. I try to connect through different ways with no luck.
First I created a UDL file and select Jet 4.0 as the provider. Then I pointed to the mdb file and typed the user id and password. Try the same within VB.NET oleDBconnection. Results are the same. Both cases it shows the following error message

"The connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user."

Although I cannot connected to a password protected database, I can use both methods successfully for unprotected databases.

Is there a difference between access database password and Jet password? In which case how can I use the Jet database pwd instead database password in UDL properties?

Do I need to install any additional components? Is there a way to fix this error. Please help.

Thanks in advance.

 

[MrFancyteeth]

just been browsing the FAQ's & noticed this..

faq796-3853

in the FAQ section

might be what you need.

mrF

 

[fordtran]

I have tried to implement this but get the error :

System.ArgumentException: Invalid path for MapPath 'databases\witbankbizclients.mdb;Jet OLEDBatabase Password=2559898'. A virtual path is expected.


fordtran

 

[ca8msm]

Is this a website or a windows application?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.