问题描述
你好，
有没有人经历过这些记录本身就是重复的。当我在
中查看我的表后端mdb文件时，有2条记录具有相同的
信息。我确定前端创造了这个记录。我怎么能解决这个问题？
这个问题？有3个用户连接到
windows 2003共享上的后端文件。我的基本表单使用子表单和访问创建的搜索字段
组合框。桌上有一张桌子，桌子上有志愿者和一张约会桌，可以绑定到一个
的客户和一名志愿者。客户和志愿者表格中的约会子表格总是存在。
提前致谢，
Nathan
Hello,
Has anyone experienced that records get duplicated by itself. When I
look in my tables backend mdb file there are 2 records with the same
information. I''m sure the frontend created this records. How can i solve
this problem? There are 3 users that connect to the backend file on a
windows 2003 share. My basic form uses subforms, and a search field
combobox created by access. There is one table with clients, on table
with volunteers and a table with appointments wich can be bound to a
client and a volunteer. The appointments subform is always present on
the client and volunteers form.
Thanks in advance,
Nathan
推荐答案
每个餐桌约会，客户和志愿者都有自己的主要
密钥和唯一索引。 De信息重复，但
autonumber id不同。
Every table appointments, clients and volunteers have there own primary
keys, and unique index. De information gets duplicated but the
autonumber id is different.
每个表都有自己的主键和带自动编号的唯一索引。
Every table has its own primary key and unique index with autonumbering.
这篇关于数据/记录复制多用户dbase的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！