Microsoft Office Access数据库引擎无法打开或写入文件''。它已由其他用户独占打开，或者您需要获得查看和写入其数据的权限。 [英] The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.

问题描述

请建议我解决这个问题的正确方法，我已经尝试了很多，但没有找到解决此错误的方法。

解决方案

如果查看文件的权限不允许您甚至读取目录内容。确保文件和目录正确共享，并且您可以通过exporer导航到它。



如果您已经检查了所有这些，那么您是否正在运行Access前端，并为登录使用设置了不同的权限？



你甚至使用Access前端来访问后端设置吗？



如果上面没有帮助那么请提供更多关于你如何设置的详细信息以及当你收到此错误时你想要做什么



^ _ ^

希望它能帮到你。

 string path = Server.MapPath（fileuploadExcel.PostedFile.FileName）; 

请参阅：

连接MS Access，而另一个应用程序使用相同的MS Acess文件 [ ^ ]

使用OLEDB连接字符串打开MS Access并且无权访问创建.ldb锁定文件 [ ^ ]

当另一个应用程序使用时连接MS Access数据库相同的MS Acess文件 [ ^ ]

https://social.msdn.microsoft.com/Forums / EN-US / c90b1166-e5ee-43ff-a49b-9efe9f416475 /开放的-MS-访问数据库中-E xclusive-mode-using-adonet？forum = adodotnetdataproviders [ ^ ]

Please suggest me a proper solution for this problem, I had tried a lot but didn't found solution for this error.

解决方案

This can happen if the permissions to view the file don't allow you to even read the directory contents. make sure that the file and directory are correctly shared and that you can navigate to it via exporer.

If you have already checked all of this then are you running Access front end with a different permission set to the logged on use?

Are you even using an Access front-end to Access back-end setup?

If the above does not help then please supply much more detail on how you are set up and what you are trying to do when you get this error

^_^

hope it will help you.

string path = Server.MapPath(fileuploadExcel.PostedFile.FileName);

Please see:
Connecting MS Access while another application using the same MS Acess File[^]
Open MS Access with OLEDB connection string and not have access create the .ldb lock file[^]
Connecting MS Access database when another application using the same MS Acess File[^]
https://social.msdn.microsoft.com/Forums/en-US/c90b1166-e5ee-43ff-a49b-9efe9f416475/opening-an-ms-access-database-in-exclusive-mode-using-adonet?forum=adodotnetdataproviders[^]

这篇关于Microsoft Office Access数据库引擎无法打开或写入文件''。它已由其他用户独占打开，或者您需要获得查看和写入其数据的权限。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！