Exception on open of Access DB (ASP.NET)

[Sonreir]

Hey all,

 

Getting this error when I try to open an access connection:

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

 

I know the file isn't open, so do I need to setup any special permissions? If so, how?

[IxiRancid]

Big problem with ASP is IIS, this Internet Information Services, when accessed by an ASPX page uses antoher system account (IUSR_machinename or ASPNET).

These two users do not have permissions on 'C:\Temp\data.dat'

Usually this is the problem.

http://www.kdkeys.net/forums/4007/ShowPost.aspx

Find some articles about user authentication and IIS, Windows Integrated security etc.

OR... just set Read/Write permissions on that folder :)