Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How this happend ???Duplicated record

Status
Not open for further replies.

fule12

Programmer
Nov 12, 2001
140
YU
hi all,
I have DB on server like Purch_be(back-end) and on workstation
Purch_fe(front-end).In Table Order field OrderID is set like PK. Same how 1
time in week or in 2 week if I run Query Find duplicate order there is 1 -
5
record duplicated. Is not only OrderID complete record is duplicated. like
twins.
So if delete first duplicated record it will delete twin order as well and
in all field for that record will be Delete#.Now when i delete all
duplicate
record and if i try to open Order table is open to me pop up window with
message "Record is deleted". So i convert and repair Purch_be.After i can
open table order and top record are one what i deleted where orderId field
is empty but two field ( orderNo and Order) are populated with
#########.Now
i delete this record and i go to design view and OrderID don't have PK
anymore!!!!
On Server I didn't install Office and all workstation use Access 2000(sr-1)
or Access 2000(sr-2).

Please Help !!
Thanks Fule
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top