您这次无权访问数据库.如果继续进行更改，则以后可能无法保存它们 [英] you do not have access to the database this time. If you proceed to make changes,you may not be able to save them later

问题描述

我是ms访问的新手.现在，我必须在ms Access 2003中完成一些修改.我收到此错误您这次没有访问数据库的权限.如果继续进行更改，以后可能无法保存它们".请帮我解决这个问题.

i am new in ms access. Now i have to finish some modifications in ms access 2003. I am getting this error "you do not have access to the database this time. If you proceed to make changes,you may not be able to save them later". Please help me to solve this problem.

推荐答案

Microsoft已记录了问题，但是在我的大多数情况下，被拖延的解决方案完全无法使用.此外，即使在拆分的数据库中也会发生此问题，并且与使用代码的表单和控件不一致地发生.我认为MS弄错了这个错误，或者至少没有完整记录.

Microsoft has documented the problem, but the sugested solutions were completly unusable in most of my situations. Furthermore the issue occurs even in a split database and it occurrs inconsistently with forms and controls that use code. In my opinion MS got this wrong or at the very least documented incompletly.

这是我的解决方案: 在许多情况下，该问题可追溯到Access认为该数据库应处于共享模式，而该数据库处于互斥模式.在选项"下将数据库设置为共享模式"无济于事，因为只要用户打开数据库中任何对象的设计视图"，或者进行代码修改，或者如果用户按，它就会恢复为独占"状态. 保存"(CTRL + S)！

Here is my solution: The problem in many instances traces back to Access thinking the DB is in an exclusive mode, when it should be in a shared mode. Setting the DB to "shared mode" under Options doesn't help, because it will revert back to "exclusive" any time a user turns on the "design view" for any object in the database OR makes code modifications OR if a user presses "save" (CTRL + S)!

为了防止错误消息弹出，您需要防止用户在数据库中按保存"或切换到设计视图".快速访问工具栏(因此用户看不到它)，在选项">当前数据库"下，我未选中允许完整菜单".此外，您还可以在同一菜单中取消选中启用布局视图".

In order to prevent the error message from poping up, you need to prevent the users from pressing "save" or switching to "design view" in your DB. I have deleted the save button in the Quick Access Toolbar (so users don't see it) and under Options>Current Database I have unchecked "Allow Full Menus". Additionally you can also uncheck "Enable Layout View" in the same menu.

可能可以同时禁用保存功能，但是我尚未为此编写代码.这个解决方案不是万无一失的，但是它大大减少了在我的各种拆分和未拆分DB中出现该问题的可能性.

Possibly the Save function can be disabled alltogether, but I have not yet written code for this. This solution is not fool proof, but it greatly reduced the occurence of the problem in my various split and unsplit DBs.

这篇关于您这次无权访问数据库.如果继续进行更改，则以后可能无法保存它们的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！