Re: Access and database connection
From: Jos (josnospambranders_at_fastmail.fm)
Date: 07/28/03
- Next message: Michal Januszczyk: "Allow domain users from anywhere ..."
- Previous message: Teemu Keiski: "Re: Protected folder with forms authentication"
- In reply to: chris: "Access and database connection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 28 Jul 2003 15:06:06 +0200
chris wrote:
> I get the following error when I try to run my web page in
> asp.net.
>
> The Microsoft Jet database engine cannot open the
> file 'c:\inetpub\wwwroot\test\test.mdb'. It is already
> opened exclusively by another user, or you need permission
> to view its data.
>
> I have gone to the User Accounts and changed all users to
> group Administrators, but still does not work. I am using
> visual studio.net, and I seem to remember changing
> permissions on a file and it seemed to work after that but
> can not remember what or where that file is located. If
> anyone can help me with this error I would be most
> appreciative.
>
> chris
This problem can have 2 causes (as indicated by the message):
1) opened by another user. This can be caused by your own
application opening the database and not closing it. Make
sure to add the line myConnection.Close() after opening a
connection. Also use exception handling, so that the
this line also executes in the case of an error.
2) you need permission. Try changing the security settings on
the database file test.mdb, by giving the ASPNET account
at least read access.
-- Jos
- Next message: Michal Januszczyk: "Allow domain users from anywhere ..."
- Previous message: Teemu Keiski: "Re: Protected folder with forms authentication"
- In reply to: chris: "Access and database connection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
