Access前端打开时，将打开链接的Excel文件-如何停止此行为 [英] Linked Excel file opens when Access front end opens- How to stop this behavior

问题描述

我有女士访问终端，该终端分发给了50多个用户，并且运行良好，直到今天我遇到了奇怪的行为.

I have Ms access- frond end which is distributed to more than 50 Users and its works very well until today i come across a weird behavior.

今天，我已经在后端链接了一个excel文件，并在前端使用了此链接表，并使用查询创建了一个表单(仅查看)并更新了我的前端.通过测试，我发现如果我打开前端的两个实例并打开新创建的表单，则在第二个实例访问中打开链接的Excel文件为只读.

today, I have linked one excel file in back end and use this linked table in front end a create a form using query (view only) and updated my front end. through my test I found that if I open two instance of my front end and open the newly created form than in second instance access open my the linked Excel file as readonly.

我的问题是，如何避免这种行为?我不希望我的用户以任何方式看到此excel文件.有什么解决办法吗?

My question is, how can i avoid this behavior? I don't want my users to see this excel file by any way. is there any work around?

推荐答案

这是设计使然.内部托管的Excel工作簿无法共享以编写.

That's by design. An Excel workbook hosted on premise cannot be shared for writing.

一种解决方法是为每个用户创建工作簿的副本.例如，让您的应用程序将工作簿从共享位置复制到用户的本地数据文件夹％LocalAppData％的本地子文件夹中，并链接到该文件夹​​.

One workaround is to create a copy of the workbook for each user. For instance, let your application copy the workbook from the shared location to a local subfolder of %LocalAppData%, the user's local data folder, and link to that.

这篇关于Access前端打开时，将打开链接的Excel文件-如何停止此行为的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！