471,079 Members | 993 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,079 software developers and data experts.

Problems accessing a password protect database

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
2 1691
- 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
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.

Similar topics

5 posts views Thread by Trev | last post: by
21 posts views Thread by solomon_13000 | last post: by
3 posts views Thread by Miro | last post: by
22 posts views Thread by teejayem | last post: by
16 posts views Thread by Greg (codepug | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.