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

Problems accessing a password protect database

P: n/a
I am using VB DotNet Std Edition and am writing a web application that needs
to read and write to an password protected database.

The mdb files reside in a folder (fpdb) under the localhost
(c:\inetpub\wwroot)

Within the IDE I can view the data using the server explorer and I use that
same oledb connection for the web form.

I have tried accessing a non-password protected db in the same folder using
the same code and that connection opens fine. So my problem must be with
the password protection.

The exception occurs when I try to open the database. It states:

"The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\fpdb\NewGoodGas.mdb'. It is already opened exclusively
by another user, or you need permission to view its data."

Anybody got any help for me here?

Dan
Nov 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
- Go to task manager to check whether you have a session of that database
open. That may coursed by your code.
- Start MS Access but not double click NewGoodGas.mdb. Open NewGoodGas.mdb
from the File -> Open dialog. Make sure you click Open button and not Open
Exclusive.

Good luck.
chanmm

"DanB" <ag*****@kc.rr.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
I am using VB DotNet Std Edition and am writing a web application that
needs
to read and write to an password protected database.

The mdb files reside in a folder (fpdb) under the localhost
(c:\inetpub\wwroot)

Within the IDE I can view the data using the server explorer and I use
that
same oledb connection for the web form.

I have tried accessing a non-password protected db in the same folder
using
the same code and that connection opens fine. So my problem must be with
the password protection.

The exception occurs when I try to open the database. It states:

"The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\fpdb\. It is already opened exclusively
by another user, or you need permission to view its data."

Anybody got any help for me here?

Dan

Nov 18 '05 #2

P: n/a
I do not use software package the MSAccess. So I don't think your suggestion
will work.

I tend to think that the problem lies in the authentication process. It is
not the same for a web site as opposed to a windows application. I can open
this database under VB Dotnet application code when designed for a windows
application but I have problems when designed for a web application. So I
think that is where the problem lies.

Dan
"chanmmn" <ch*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
- Go to task manager to check whether you have a session of that database
open. That may coursed by your code.
- Start MS Access but not double click NewGoodGas.mdb. Open NewGoodGas.mdb
from the File -> Open dialog. Make sure you click Open button and not Open
Exclusive.

Good luck.
chanmm

"DanB" <ag*****@kc.rr.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
I am using VB DotNet Std Edition and am writing a web application that
needs
to read and write to an password protected database.

The mdb files reside in a folder (fpdb) under the localhost
(c:\inetpub\wwroot)

Within the IDE I can view the data using the server explorer and I use
that
same oledb connection for the web form.

I have tried accessing a non-password protected db in the same folder
using
the same code and that connection opens fine. So my problem must be with the password protection.

The exception occurs when I try to open the database. It states:

"The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\fpdb\. It is already opened exclusively
by another user, or you need permission to view its data."

Anybody got any help for me here?

Dan


Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.