Connecting to Password Protected MS Access DB

A

A P

Hi!

I am trying to connect to MS Access DB that was password protected but I
dont know what to do. What I did is I select the path of the file then I
enter Admin as its username and when I type the password to open the DB,
checked the Allow saving password checkbox, then click on the Test
Connection button, I got an error message

" MS Data Link Error: Test 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."

I use Microsoft Jet 4.0 OLE DB Provider. If I will remove the password, I
can connect to the DB but this settings was not possible since the database
is still open for MS Access Form Interface. Please help me.

Me
 
M

MikeD

A P said:
Hi!

I am trying to connect to MS Access DB that was password protected but I
dont know what to do. What I did is I select the path of the file then I
enter Admin as its username and when I type the password to open the DB,
checked the Allow saving password checkbox, then click on the Test
Connection button, I got an error message

" MS Data Link Error: Test 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."

I use Microsoft Jet 4.0 OLE DB Provider. If I will remove the password, I
can connect to the DB but this settings was not possible since the
database
is still open for MS Access Form Interface. Please help me.
Click to expand...


That sounds much more like ODBC than the Jet 4.0 OLEDB Provider. It sounds
to me like you're setting up a DSN. If so, that's ODBC. There are two
possible passwords that can be configured for an .mdb file. One is a file
password. The other is a user password (i.e. user-level security). Which
are you using? My guess would be a user password. This password is saved in
a workgroup information file (a file with an .mdw extension) along with all
user names and the permissions each user has. If you use user-level
security, you must include a workgroup information file that has all this
information.
 
A

A P

MikeD is asking what kind of password that I have on my database. I just
answer what he replied to me that he is guessing that I an using a user
level password and what I say that "hes wrong with his guess". Sorry if you
misinterpret me with my answer.
 
M

MikeD

A P said:
MikeD is asking what kind of password that I have on my database. I just
answer what he replied to me that he is guessing that I an using a user
level password and what I say that "hes wrong with his guess". Sorry if
you
misinterpret me with my answer.
Click to expand...


I gotta go with A P on this. <g> You all are taking much more offense at
his reply than I did. I definately thought that A P could have used a little
more tact and grace, but I certainly wasn't offended or anything like that.
I was just taking a guess that it was a user-level password. Apparently, I
guessed wrong and was told so. So what?
 
S

Stefan Berglund

in said:
I gotta go with A P on this. <g> You all are taking much more offense at
his reply than I did. I definately thought that A P could have used a little
more tact and grace, but I certainly wasn't offended or anything like that.
I was just taking a guess that it was a user-level password. Apparently, I
guessed wrong and was told so. So what?
Click to expand...


Phew! That was exactly how I read it also and I was trying to figure out if
there was some disturbance in the force that I was unaware of or something else
that could have caused that to get blown completely out of proportion as it
obviously was.
 
J

Joan Wild

A P said:
MikeD is asking what kind of password that I have on my database. I just
answer what he replied to me that he is guessing that I an using a user
level password and what I say that "hes wrong with his guess". Sorry if
you
misinterpret me with my answer.
Click to expand...


I don't think you've got an answer yet. Anyway check out item 43 in the
Security FAQ at
http://support.microsoft.com/?id=207793
"How do I open a password-protected database from Visual Basic"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connect to Remote Access Server 5
Cannot open password protected Access DB 7
access connectionss 3
Error ocurred when try to connect Access 3
Compacting remote password-protected db 4
re-linking Access db to new updated SQL 2005 DB 3
Problem connecting to password protected Access file 4
Connect to a password protected MS Access DB 2

Top