problem while connecting to a secured MS Assess DB

[Reny J Joseph Thuthikattu]

Hi,

I am having problem while connecting to a passowrd protected db from
viewing.Since i want to protect the database file , i created one for that
db by opening it exclusively, then from tools->security->user and group
accounts->change log on password .From there i setup a password for admin as
Administer.I can manualy open the file by giving user name and password from
MS Access .While trying to connect to it through VB.NET i am getting error
as

Can not start your application.The workgroup information file is missing or
opened exclusively by another user.

The connection string i used is ----

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Program
Files\communication\db.mdb;User Id=Admin;Password=Administer;



Please help me out

Reny

 

[Mary Chipman]

I notice that you have confused the database password feature with
user-level security, which are two different implementations. Even
when correctly implemented, Access/Jet security is difficult to work
with from client applications since you also need to specify the mdw
file in the connection string. Most developers have concluded that
Access/Jet security is a waste of time. Anyone who can do a google
search can easily bypass it. I'd recommend going with the default
unsecured mdb/mdw. However, if you're still not convinced, you can fix
up the connection string from examples at
http://www.able-consulting.com/ADO_Conn.htm.

--Mary

 

[Paul Clement]

¤ Hi,
¤
¤ I am having problem while connecting to a passowrd protected db from
¤ viewing.Since i want to protect the database file , i created one for that
¤ db by opening it exclusively, then from tools->security->user and group
¤ accounts->change log on password .From there i setup a password for admin as
¤ Administer.I can manualy open the file by giving user name and password from
¤ MS Access .While trying to connect to it through VB.NET i am getting error
¤ as
¤
¤ Can not start your application.The workgroup information file is missing or
¤ opened exclusively by another user.
¤
¤ The connection string i used is ----
¤
¤ Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Program
¤ Files\communication\db.mdb;User Id=Admin;Password=Administer;
¤
¤
¤
¤ Please help me out

Please see the responses to the previous thread you started.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)