The Microsoft Jet database engine cannot open the file

[Dave]

This is my first .NET project (although I am experienced with VS6 and
InterDev). I am simply trying to set up a basic ASPX project and connect to
an Access database (following the instructions in the .NET Black Book by
Templeman and Vitter). I have managed to set up an oleDbConnection , an
oleDbAdapter and a dataset, and have added one line of code:
oleDbDataAdapte r1.Fill(dataSet 1);
However when this line of code executes I get whole page of error headed
"The Microsoft Jet database engine cannot open the file 'C:\Documents and
Settings\Dave\P AW Files\Databases \Friends\Friend s.mdb'. It is already opened
exclusively by another user, or you need permission to view its data."
I am using Access 2000 SP3 and Windows XP SP2. There is no remote access,
the web application is being served from C:\Inetpub\wwwr oot by IIS5.1 (which
I think was installed when I installed VS6/Visual Interdev).
It's my very first attempt at .NET and I'm getting nowhere. Can somebody
please help.
--
Dave

[Paul Clement]

On Wed, 3 Aug 2005 06:27:05 -0700, "Dave" <Da**@discussio ns.microsoft.co m> wrote:

¤ This is my first .NET project (although I am experienced with VS6 and
¤ InterDev). I am simply trying to set up a basic ASPX project and connect to
¤ an Access database (following the instructions in the .NET Black Book by
¤ Templeman and Vitter). I have managed to set up an oleDbConnection , an
¤ oleDbAdapter and a dataset, and have added one line of code:
¤ oleDbDataAdapte r1.Fill(dataSet 1);
¤ However when this line of code executes I get whole page of error headed
¤ "The Microsoft Jet database engine cannot open the file 'C:\Documents and
¤ Settings\Dave\P AW Files\Databases \Friends\Friend s.mdb'. It is already opened
¤ exclusively by another user, or you need permission to view its data."
¤ I am using Access 2000 SP3 and Windows XP SP2. There is no remote access,
¤ the web application is being served from C:\Inetpub\wwwr oot by IIS5.1 (which
¤ I think was installed when I installed VS6/Visual Interdev).
¤ It's my very first attempt at .NET and I'm getting nowhere. Can somebody
¤ please help.

See the following MS KB article:

PRB: Cannot connect to Access database from ASP.NET
http://support.microsoft.com/default...b;en-us;316675
Paul
~~~~
Microsoft MVP (Visual Basic)

[Dave]

Thanks Paul. That's one I hadn't found.

I have now enabled impersonation on my project. However, I now have a bigger
problem - the same line of code now generates "Unspecifie d error: An
unhandled exception occurred during the execution of the current web request."

Any ideas?
--
Dave
"Paul Clement" wrote:

On Wed, 3 Aug 2005 06:27:05 -0700, "Dave" <Da**@discussio ns.microsoft.co m> wrote:

¤ This is my first .NET project (although I am experienced with VS6 and
¤ InterDev). I am simply trying to set up a basic ASPX project and connect to
¤ an Access database (following the instructions in the .NET Black Book by
¤ Templeman and Vitter). I have managed to set up an oleDbConnection , an
¤ oleDbAdapter and a dataset, and have added one line of code:
¤ oleDbDataAdapte r1.Fill(dataSet 1);
¤ However when this line of code executes I get whole page of error headed
¤ "The Microsoft Jet database engine cannot open the file 'C:\Documents and
¤ Settings\Dave\P AW Files\Databases \Friends\Friend s.mdb'. It is already opened
¤ exclusively by another user, or you need permission to view its data."
¤ I am using Access 2000 SP3 and Windows XP SP2. There is no remote access,
¤ the web application is being served from C:\Inetpub\wwwr oot by IIS5.1 (which
¤ I think was installed when I installed VS6/Visual Interdev).
¤ It's my very first attempt at .NET and I'm getting nowhere. Can somebody
¤ please help.

See the following MS KB article:

PRB: Cannot connect to Access database from ASP.NET
http://support.microsoft.com/default...b;en-us;316675
Paul
~~~~
Microsoft MVP (Visual Basic)

[Paul Clement]

On Wed, 3 Aug 2005 08:49:41 -0700, "Dave" <Da**@discussio ns.microsoft.co m> wrote:

¤ Thanks Paul. That's one I hadn't found.
¤
¤ I have now enabled impersonation on my project. However, I now have a bigger
¤ problem - the same line of code now generates "Unspecifie d error: An
¤ unhandled exception occurred during the execution of the current web request."
¤
¤ Any ideas?

Sounds like there is still a security issue although the error isn't very descriptive. What level of
authentication are you using? If it's Anonymous and impersonation is enabled, then you probably need
to provide full permissions for the folder where the Access database is located to IUSR<machinenam e>
account.
Paul
~~~~
Microsoft MVP (Visual Basic)

[Dave]

I am using anonymous authentication I think. I am reading a lot of stuff and
getting very confused. Is it the IUSR_<machinena me> user I need to grant
permissions to, or is it ASPNET?
I think one of my problems is that my system uses something called
"guest-only" security instead of "classic" security. Does that make sense? I
think I need to change that first.
--
Dave
"Paul Clement" wrote:

On Wed, 3 Aug 2005 08:49:41 -0700, "Dave" <Da**@discussio ns.microsoft.co m> wrote:

¤ Thanks Paul. That's one I hadn't found.
¤
¤ I have now enabled impersonation on my project. However, I now have a bigger
¤ problem - the same line of code now generates "Unspecifie d error: An
¤ unhandled exception occurred during the execution of the current web request."
¤
¤ Any ideas?

Sounds like there is still a security issue although the error isn't very descriptive. What level of
authentication are you using? If it's Anonymous and impersonation is enabled, then you probably need
to provide full permissions for the folder where the Access database is located to IUSR<machinenam e>
account.
Paul
~~~~
Microsoft MVP (Visual Basic)

[Paul Clement]

On Thu, 4 Aug 2005 09:04:08 -0700, "Dave" <Da**@discussio ns.microsoft.co m> wrote:

¤ I am using anonymous authentication I think. I am reading a lot of stuff and
¤ getting very confused. Is it the IUSR_<machinena me> user I need to grant
¤ permissions to, or is it ASPNET?
¤ I think one of my problems is that my system uses something called
¤ "guest-only" security instead of "classic" security. Does that make sense? I
¤ think I need to change that first.

If impersonation is enabled with Anonymous access then the IUSR (or IWAM) account is used depending
upon the Application Settings in IIS for the app. If impersonation is not enabled then the account
used is ASPNET (NetworkService in Windows 2003).
Paul
~~~~
Microsoft MVP (Visual Basic)