访问问题 - 数据已分布在同一数据库的两个不同副本中 [英] ACCESS PROBLEM - Data has been split across two different copies of the same database

问题描述

 

    我有一个Access数据库被复制到另一个全新的文件服务器。 我将共享从旧文件服务器断开，以便他们无法访问它，但有人正在浏览另一个我在旧服务器上看不到的共享
。

     I have one Access Database that was copied over to a different file server that is brand new.  I disconnected the share from the old file server so that they couldn't get access to it, but someone was going through another share that I didn't see on the old server.

  因此，一些数据位于访问数据库的新副本上，一些数据位于以前服务器上的旧副本上。

   So, some of the data is on the new copy of the access database and some is on the old copy on the previous server.

 

问题＃1：  

QUESTION #1:   

如何找出两个数据库之间缺少的数据？  

How can I find out what data is missing between the two databases?  

问题＃2：

如何将丢失的数据复制到新版本的数据库？

How do I copy that missing data over to the new version of the database?

推荐答案

一个选项是将一个前端链接到两个后端文件，并使用查询来比较这两个文件。然后，您可以使用APPEND查询在找到后添加缺失的记录。

One option is to link one front end to both back end files and use a query to compare the two. You can then use an APPEND query to add the missing records once you found them.

希望它有所帮助......

Hope it helps...

这篇关于访问问题 - 数据已分布在同一数据库的两个不同副本中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！