LinkMasterFields属性问题：OLE服务器或ActiveX控件 [英] LinkMasterFields Property issue: OLE server or ActiveX Control

问题描述

我得到了这个LinkMasterFields属性设置产生了这个错误：''当Microsoft Office Access与OLE服务器或ActiveX控件''进行通信时出现问题我尝试添加/编辑行项目到子窗体时出现错误消息，当我单击确定，我可以进行更改，但更改不会保存到数据库。


这个只有在我尝试远程使用Access数据库时才会发生。当我进入服务器并在子窗体中添加/编辑行项目时，工作正常。


我已经获取了生产数据库的副本并将其粘贴到生产服务器本身的其他文件夹中。我在表中添加了几个字段，修改了包含子表单的Query和修改后的表单。然后，我尝试添加订单项。在服务器上工作正常，但是当我从本地机器访问数据库时，n尝试在子表单中添加行项目，我得到上面提到的错误。但是生产数据库也能很好地远程工作。


请帮助!!!

I get this "The LinkMasterFields Property setting has produced this error: ''A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control'' " error message when I try to add/edit line item to the subform and when I click OK, I am able to make changes, but the changes are not saved to the database.

This happens only when I try to use Access Database remotely. things work fine when I go to the server and add/edit line items in subform.

I have taken a copy of production database and pasted it in some other folder on production server itself. I added few fields to the table, modified Query and modified form containing subform. Then, I try to add line items. things work fine on server, but when I access the database from local machine, n try to add line items in subform, I get the above mentioned error. but the production database works fine remotely as well.

Please help!!!

推荐答案

这个数据库是否被分成了前端/后端配置，或者您是否尝试访问共享服务器上的非拆分数据库？


欢迎使用字节！


Linq ; 0）>

Has this database been split into a front end/back end configuration, or are you trying to access a non-split database on a shared server?

Welcome to Bytes!

Linq ;0)>

我正在尝试访问服务器上的非拆分数据库，该文件夹包含已与少数用户共享数据库，这些用户将在需要时进行更改。我认为当我对包含子表单的表单进行更改时会出现问题

I am trying to access a non-split database on the server, the folder containing the database has been shared with few users who will make changes when required. I think issue occur when I make change to the form containing subform

您永远不应该对正在使用的数据库进行设计更改。


这就是拆分FE& BE和发布（修订版）FE的新版本是如此受欢迎的设置。如果你想在将来避免这些问题，我建议你以相同的方式组织事情。

You should never work on design changes of a database that''s in use.

This is why splitting the FE & BE and releasing a new version of the (amended) FE is such a popular setup. I suggest you organise things the same way if you want to avoid such issues in future.

这篇关于LinkMasterFields属性问题：OLE服务器或ActiveX控件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！