错误消息:另一个用户已经以独占方式访问 [英] Error message : Access already exclusively by another user

问题描述

可能重复:
无法使用oledb打开XLS文件

Possible Duplicate:
Trouble to open XLS file with oledb

我在newtwork驱动器上有一个已编译的Microsoft Access数据库(* .mde).当我尝试通过IIS 7.5(Windows Server 2008)上的myapplication(ASP.NET)打开它时，出现此错误:

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 :

Microsoft Access数据库引擎无法打开或写入文件. 它已经由另一个用户专门打开，或者您需要 有权查看和写入其数据.

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.

除IIS之外，任何人都不能使用此文件.

This file is not use by anyone except by IIS.

有什么主意吗?

谢谢

推荐答案

仅对该文件具有写许可权，您还必须对该文件所在的文件夹具有写许可权，因为Access创建了一个锁定文件( * ldb)必须为每个连续的用户写入，否则第一个打开文件的用户将锁定它.在这种情况下，IUSR，AFIAK需要获得许可.

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.

这篇关于错误消息:另一个用户已经以独占方式访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！