MS Access 2010在共享模式下无法正常工作,但在独占模式下可以正常工作 [英] MS Access 2010 does not work properly in shared mode, but does work properly in exclusive mode

查看:83
本文介绍了MS Access 2010在共享模式下无法正常工作,但在独占模式下可以正常工作的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

自从一周前手动运行以来,我一直遇到MS Access 2010的问题。安装了2014年初的更新。


我的环境是:"Windows Server 2008 R2"许多用户正在运行"Windows 7 Pro"桌面。没有定义工作组。 Access DB位于共享模式下的多个服务器上。开发工作在本地机器C:驱动器上完成。


问题1.在排除模式下打开accdb并通过单击表单按钮执行一些vba代码后,我收到错误3045 ,"无法使用>>文件路径和名称<< ;;文件已被使用"。 "Set DB = CurrentDb"上的代码错误。
这只发生一次。通过停止代码执行(重置按钮)并再次单击表单按钮,所有代码和表单都能正常工作,直到文件关闭并重新打开。


问题2.在共享中模式,表单按钮应该为用户显示一组记录。表单不会填充数据,而是填充空白表单。表单记录源是一个在手动打开时正确显示的查询。


问题3.在从我的C:驱动器打开的共享模式下,我收到消息"您没有独占访问权限此时的数据库。",但仅在执行了vba代码之后。通过执行紧凑修复,此问题将得到纠正,直到下一个vba代码执行


这些问题导致Access 2010无法用于任何新应用程序,直到可以解决它们为止。


你能帮忙吗?




有关的其他信息问题2.

执行vba代码后执行压缩/修复会重置"您目前没有对数据库的独占访问权限"。问题。可以编辑表单和代码,直到下一个vba代码运行。在压缩后,我在共享的
模式中也看到了问题no.1三次。

我看到vba记录集开放事件有很长时间的延迟。表单打开空白的原因是因为代码在记录集打开之前继续执行。我找到了临时工作。


通过添加代码暂停功能,表单可以正常打开,但只能延迟700毫秒。编辑记录时,我现在收到消息"另一个用户编辑了此记录,并在您尝试保存更改之前保存了更改。"
$
移动DB.close并设置db =在700ms延迟之前没有任何声明,此消息不会出现。在代码执行之前,文件锁显示Computername(nul)和Admin(nul)。代码执行后,文件锁显示Computername(nul),Admin(nul),
Computername(nul),admin(nul)。

第一个Admin大写,第二个是全部更低case。

我希望这会有所帮助。


解决方案


这是讨论Microsoft Office问题和反馈的论坛,这个问题与开发有关,我会把你的问题转到MSDN论坛进行访问



I have been experiencing problems with MS Access 2010 since manually running updated a week ago. Updates from the beginning of 2014 were installed.

My environment is: "Windows Server 2008 R2" with many users running "Windows 7 Pro" desktops. There is no Workgroup defined. Access DB's reside on multiple servers in Shared Mode. Development work is done on the local machines C: drive.

Problem 1. After opening an accdb in exculsive mode and executing some vba code by clicking a form button, I receive error 3045, "Could not use >>file path and name<<; file already in use". The code errors on "Set DB = CurrentDb". This happens one time only. By stopping the code execution(reset button) and clicking the form button a second time, all code and forms work properly until the file is closed and reopened.

Problem 2. In shared mode, the form button should display a set of records for the user. The form does not populate with data, instead, it is a blank form. The forms recordsource is a query that displays correctly when opened manually.

Problem 3. In shared mode opened from my C: drive, I receive the message "You do not have exclusive access to the database at this time.", but only after vba code has been executed. By performing a compact repair, this problem is corrected until the next vba code execution.

These problems have rendered Access 2010 unusable for any new applications until they can be resolved.

Can you help?

Additional information pertaining to problem 2.
Performing a compact/repair after vba code execution resets the "You do not have exclusive access to the database at this time." problem. Forms and code can be edited until the next vba code run. I have also seen problem no.1 three times in shared mode after the compact.
I am seeing a long delay on the vba recordset open events. The reason the form opens blank is because code continues to execute before the recordset has opened. I have found a temporary work around.
By adding a code pause funtion, the form opens properly, but only after a 700 millisecond delay. When a record is edited, I now receive the message "Another user edited this record and saved the changes before you attempted to save your changes."
By moving the DB.close and set db = nothing statements before the 700ms delay, this message does not appear. Before code execution the file lock shows Computername(nul) and Admin(nul). After code execution the file lock shows Computername(nul), Admin(nul), Computername(nul), admin(nul).
The first Admin is capitalized and the second is all lower case.
I hope this is helpful.

解决方案

Hi,

This is the forum to discuss questions and feedback for Microsoft Office, this issue is more related to the develop, I'll move your question to the MSDN forum for Access

http://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

George Zhao
TechNet Community Support


这篇关于MS Access 2010在共享模式下无法正常工作,但在独占模式下可以正常工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
相关文章
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆