Error message : Access already exclusively by anot

Question

Possible Duplicate:
Trouble to open XLS file with oledb

I have a compiled Microsoft Access database (*.mde) on a newtwork drive. When I try to open it via myapplication (ASP.NET) on IIS 7.5 (Windows Server 2008) I get this error :

The Microsoft Access database engine cannot open or write to the file. It's already opended exclusively by another user, or you need permission to view and write its data.

This file is not use by anyone except by IIS.

Any idea ?

Thanks,

Answer 1

It is not sufficient to have write permission on the file, you must also have write permissions on the folder in which the file resides because Access creates a lock file (*ldb) which has to be written to for each successive user, otherwise the first user to open the file will lock it. In this case, permission is required by IUSR, AFAIK.