Re: MS Access can't open file
- From: "S. Justin Gengo" <justin@[no_spam_please]aboutfortunate.com>
- Date: Mon, 12 Dec 2005 13:31:55 -0600
You need to give the account your website is running as (it could be
IIS_User or ASPNET depending on whether you have an Identity Impersonate tag
in your web.config file or not) read and write permissions to the folder
that your database is in. To do so navigate to that folder, right click on
it and click properties. If you don't see a "Security" tab in the properties
window for that folder you'll need to reveal it (It's hidden by default on
Windows XP). To reveal the security tab in a folder browsing window click
Tools - Folder Options and then click on the "View" tab. at the very bottom
of the Advanced settings list uncheck "Use simple file sharing"
Then when you right click a folder and choose properties you'll see a
"Security" tab where you may set the permissions.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer
www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"semesm22" <sampoetmoh2@xxxxxxxxx> wrote in message
news:OyN2EF0$FHA.4036@xxxxxxxxxxxxxxxxxxxxxxx
> hello all, i am using asp.net with IIS on a Windows XP machine to open
> an Access database, and i know that this topic has been posted on forums
> hundreds of times, but i can't find an answer that works..
>
> here is the problem, i m opening the database with OleDBConnenction and
> OleDbCommand...but i get this error:
>
> The Microsoft Jet database engine cannot open the file
> 'C:\Database\database.mdb'. It is already opened exclusively by another
> user, or you need permission to view its data.
>
> HOWEVER, when i put the database in D:\Database, it works just
> fine.....i researched the forums to find an answer, i even found a topic
> on MSDN, but that related to server based IIS, and not WIN XP, it was
> talking about permissions to everyone, which is something not found on
> WIN XP....the problem is that i am doing this for a college assignment,
> and i need to hand in the database in the same folder that contains my
> web forms and web.config and all that.....i tried to use
> Server.MapPath("..\Database\Database.mdb"), but that also didn't
> work....can anyone help please...
>
> thanks
>
> --
> Sent via .NET Newsgroups
> http://www.dotnetnewsgroups.com
.
- Follow-Ups:
- Re: MS Access can't open file
- From: semesm22
- Re: MS Access can't open file
- From: semesm22
- Re: MS Access can't open file
- References:
- MS Access can't open file
- From: semesm22
- MS Access can't open file
- Prev by Date: New ASP.NET 2.0 Design Templates
- Next by Date: Re: newbie quest about System.Timers.Timer
- Previous by thread: MS Access can't open file
- Next by thread: Re: MS Access can't open file
- Index(es):
Relevant Pages
|
