DB_SEC_E_AUTH_FAILED's offspring

[Reymond Charalambous via DotNetMonster.com]

I tried to open an ole db connection to an .mdb file and it gave me an
DB_SEC_E_AUTH_FAILED exception. I changed the double quotes in the
connection string from "" to """", and it gave me the following error:

-2147467259 The Microsoft Jet database engine cannot open the file 'E:\
Inetpub\wwwroot\Vantage Wines\Assignment.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.

The same error persists even when I ommit the double quotes altogether. I
tried to open several .mdb files and I get the same error every time.

Please help. My email address is (e-mail address removed). If you have any
suggestions I'm all ears.

Thanks.

Rey

 

[Ken Cox [Microsoft MVP]]

Hi Reymond,

This usually means that the account that is running ASP.NET (ASPNET) doesn't
have write permissions in the directory where the .mdb file is located.
Access wants to creating a locking (.ldb) file for its own purposes.