Home All Groups Group Topic Archive Search About

Ah Ha! I have narrowed it down

Author
1 Aug 2006 7:52 AM
samadams_2006
I took off "friendly messaging" for the browser, and now have a more
descriptive error for this problem.  It says:

The Microsoft Jet database engine cannot open the file
'D:\databases\guest.mdb'.  It is already opened exclusively by another
user, or you need permission to view its data.

I have just rebooted the PC, so it cannot be opened exclusively by
another user.  When I define the Connection String in the
OleConnection1, I have:

Provider Tab
------------------
a)  Microsoft Jet 4.0 OLE DB Provider

Connection Tab
-----------------------
a)  I select the database "guestbook.mdb"
b)  User name:  Admin
c)  I click on "Blank password", but not "Allow saving password"

Advanced Tab
--------------------
a)  I choose "Share Deny None"

When the wizard is about to close I select:  "Include Password"

This didn't work, and I've played around with the settings, but to no
avail.  What's wrong?

Thanks

Author
1 Aug 2006 4:45 PM
Göran_Andersson
Have you granted access to the database file for the user account that
is running the code? The account is usually ASPNET or IIS_WPG.

samadams_2***@yahoo.ca wrote:
Show quoteHide quote
> I took off "friendly messaging" for the browser, and now have a more
> descriptive error for this problem.  It says:
>
> The Microsoft Jet database engine cannot open the file
> 'D:\databases\guest.mdb'.  It is already opened exclusively by another
> user, or you need permission to view its data.
>
> I have just rebooted the PC, so it cannot be opened exclusively by
> another user.  When I define the Connection String in the
> OleConnection1, I have:
>
> Provider Tab
> ------------------
> a)  Microsoft Jet 4.0 OLE DB Provider
>
> Connection Tab
> -----------------------
> a)  I select the database "guestbook.mdb"
> b)  User name:  Admin
> c)  I click on "Blank password", but not "Allow saving password"
>
> Advanced Tab
> --------------------
> a)  I choose "Share Deny None"
>
> When the wizard is about to close I select:  "Include Password"
>
> This didn't work, and I've played around with the settings, but to no
> avail.  What's wrong?
>
> Thanks
>