数据/记录复制多用户dbase [英] data / record duplication multiuser dbase
问题描述
你好，
有没有人经历过这些记录本身就是重复的。当我在
中查看我的表后端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
推荐答案
On Sun，2007年7月8日00:31:46 +0200，nathan< ur ***** @ wanadoo.nlwrote：
一个好的数据库设计可以防止主键上的不合逻辑重复
和唯一索引。
-Tom。
On Sun, 08 Jul 2007 00:31:46 +0200, nathan <ur*****@wanadoo.nlwrote:
A good database design prevents illogical duplicates with primary keys
and unique indexes.
-Tom.
>您好，
有没有人经历过这些记录本身就是重复的。当我查看我的表后端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
nathan写道：
nathan wrote:
你好，
有没有人经历过这些记录本身就是重复的。当我在
中查看我的表后端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.
Tom van Stiphout写道：
Tom van Stiphout wrote:
On Sun，2007年7月8日00:31:46 +0200，nathan< ur ***** @ wanadoo.nlwrote：
一个好的数据库设计可以防止带有主键的不合逻辑的副本
和唯一索引。
-Tom。
On Sun, 08 Jul 2007 00:31:46 +0200, nathan <ur*****@wanadoo.nlwrote:
A good database design prevents illogical duplicates with primary keys
and unique indexes.
-Tom.
>您好，
有没有人经历过这些记录本身就是重复的。当我查看我的表后端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
每个表都有自己的主键和带自动编号的唯一索引。
Every table has its own primary key and unique index with autonumbering.
这篇关于数据/记录复制多用户dbase的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
