By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,035 Members | 1,543 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,035 IT Pros & Developers. It's quick & easy.

Password problem of MS Access

P: n/a
Hi all,

I have a MS Access database (say abc.mdb). I have set the database password
and admin password to "abcdefg" (say). The problem is that when I create a
simple application (a form-based application or asp.net application) and try
to connect to the database using ado.net i get following error:

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.

Can you please identify what is wrong and how can I overcome this. For
security reasons the MS access database file must have password but when I
set password it gives me above error while connecting to it via ado.net and
if I remove the password it works alright.

Thanks,

Arsalan Ahmad
Nov 18 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Are you changing your connection string to include password when you add it?
"Arsalan Ahmad" <ar*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Hi all,

I have a MS Access database (say abc.mdb). I have set the database password and admin password to "abcdefg" (say). The problem is that when I create a
simple application (a form-based application or asp.net application) and try to connect to the database using ado.net i get following error:

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.

Can you please identify what is wrong and how can I overcome this. For
security reasons the MS access database file must have password but when I
set password it gives me above error while connecting to it via ado.net and if I remove the password it works alright.

Thanks,

Arsalan Ahmad

Nov 18 '05 #2

P: n/a
Yes I am.

"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:uP**************@TK2MSFTNGP09.phx.gbl...
Are you changing your connection string to include password when you add it? "Arsalan Ahmad" <ar*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Hi all,

I have a MS Access database (say abc.mdb). I have set the database

password
and admin password to "abcdefg" (say). The problem is that when I create a simple application (a form-based application or asp.net application) and

try
to connect to the database using ado.net i get following error:

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.

Can you please identify what is wrong and how can I overcome this. For
security reasons the MS access database file must have password but when I set password it gives me above error while connecting to it via ado.net

and
if I remove the password it works alright.

Thanks,

Arsalan Ahmad


Nov 18 '05 #3

P: n/a
can you post the string? make sure to replace the real password though with
a fake one ;-)
"Arsalan Ahmad" <ar*****@hotmail.com> wrote in message
news:e0**************@TK2MSFTNGP12.phx.gbl...
Yes I am.

"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:uP**************@TK2MSFTNGP09.phx.gbl...
Are you changing your connection string to include password when you add it?
"Arsalan Ahmad" <ar*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Hi all,

I have a MS Access database (say abc.mdb). I have set the database

password
and admin password to "abcdefg" (say). The problem is that when I
create a simple application (a form-based application or asp.net application)
and
try
to connect to the database using ado.net i get following error:

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.

Can you please identify what is wrong and how can I overcome this. For
security reasons the MS access database file must have password but
when
I set password it gives me above error while connecting to it via

ado.net and
if I remove the password it works alright.

Thanks,

Arsalan Ahmad



Nov 18 '05 #4

P: n/a
On Fri, 30 Apr 2004 10:03:22 +0500, "Arsalan Ahmad" <ar*****@hotmail.com> wrote:

Yes I am.


You need to specify the path to the System.mdw file:

"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\Secure db1.mdb;" & _
"Jet OLEDB:Engine Type=5;" & _
"Jet OLEDB:System database=E:\...\System.MDW;", "userID", "password"
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 18 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.