使用 Access 2010 修改复制数据库 [英] Modifying Replicated Database Using Access 2010

问题描述

我们有一个系统，它使用复制来允许两个不同位置的人使用一个公共数据库后端.网络质量不高，而且速度很慢，所以我使用复制在每个位置放置一个后端并使它们保持同步.同步是通过按计划运行的复制管理器和同步器完成的.这在过去两年中一直很有效.该系统最初是与 Access 2007 一起开发和使用的，但后端为 mdb 格式.所以现在客户端可以使用 Access 2010.客户端想要对后端进行一些更改，需要一些新表和添加到现有表的新字段.我觉得没问题.我去了网站，用Access 2010打开Replica set design master，添加新表没问题.然后我尝试将新字段添加到现有表中.我可以在设计视图中执行此操作，但是当我尝试保存更改时，我收到一条消息此类型的对象不支持操作"消息.我用头撞墙了一会儿，以为我做错了什么，然后放弃了在客户设施的工作.我在离开之前确实运行了同步器，并且新表正确地传播到了其他托管数据库.这部分正在工作.

We have a system that uses replication to allow folks in two different locations to work with a common database back end. The network is not high quality, and slow so I used replication to put a back end at each location and keep them synchronized. Synchronization is done through the Replication Manager and synchronizer running on a schedule. This has been working great for the past two years. The system was originally developed and used with Access 2007 but with the back end in mdb format. So now the client is up to Access 2010. The client wanted some changes to the back end, entailing some new tables and new fields added to existing tables. No problem I think. I went to the site and opened the Replica set design master using Access 2010 and added the new tables with no problem. Then I tried to add the new fields to existing tables. I could do that in design view but when I tried to save the changes I get a message 'Operation not supported for this type of object' message. I banged my head against the wall for a while thinking I was doing something wrong, then gave up working at the client facility. I did run the synchronizer before leaving and the new tables propagated properly to the other managed databases. This part is working.

回到我的办公室后，我想这可能是 Access 2010 的问题.我启动了一个装有 Access 2007 的虚拟机和一个运行相同数据库的复制系统.在 Access 2007 中，我可以打开设计母版并将字段添加到现有表中而不会出错，并且更改将被保存.这是 Access 2010 的问题还是有其他问题?我不想在其中一台客户端计算机上重新安装 Access 2007 来进行这些更改.我的 Access 2010 机器上运行着相同的系统，我可以在办公室使用 Access 2010 复制此类对象不支持操作"的问题.有什么想法吗?

After returning to my office I thought possibly this is an Access 2010 issue. I fired up a virtual machine with Access 2007 on it and a running replication system of the same database. In Access 2007 I could open the design master and add fields to existing tables with no errors and the changes would save. Is this an Access 2010 issue or is there something else going on? I'd hate to have to re-install Access 2007 on one of the client computers to make these changes. I have the same system running on my Access 2010 machine and I can duplicate the 'Operation not supported for this type of object' issue using Access 2010 in my office. Any thoughts?

预先感谢您的帮助.

推荐答案

旧线程，但我也遇到了同样的问题.我发现在 SQL 窗口中使用 Access DDL(例如 ALTER TABLE)可以修改 Access 2010 中复制数据库中的表设计.它不允许您修改现有字段/列，但您至少可以添加或删除字段从现有表.您可以使用 DDL 修改现有字段，方法是按照您希望的方式向表中添加新的临时字段，将数据从现有字段复制到临时字段，然后删除现有字段.然后使用您删除的字段的名称添加第二个新字段，并从临时字段复制数据.然后删除临时字段.更多访问 DDL 信息 这里

Old thread but I have also run into the same problems. I found that using Access DDL (e.g. ALTER TABLE) in the SQL window works to modify table design in a replicated database in Access 2010. It won't allow you to modify an existing field/column but you can at least add or drop fields from existing tables. You can use DDL to modify an existing field by adding a new temporary field to your table the way you want it, copy the data from the existing field to your temporary field, then drop the existing field. Then add a second new field with the name of the field you deleted and copy the data over from the temporary field. Then delete the temporary field. More Access DDL info here

这篇关于使用 Access 2010 修改复制数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！