SQL Server 2000/Access 2000 linked tables PK = FLOOR/DESK NO/TYPE
A User has complained about seeing data below simply by scrolling
through the attached table, the data is there when you look at the
table using Query Analyser...... any idea's ?
Example of repeated and missing rows - 109 - 112 are missing, whilst
113-116 are repeated. Happy to show Tony but I haven't experience
rows shifting before my eyes recently!!
FLOOR DESK NO TYPE Spare Extension Spare Desktop Spare Laptop
4 108 OPEN PLAN WORKSTATIONS 5768
4 113 OPEN PLAN WORKSTATIONS
4 114 OPEN PLAN WORKSTATIONS 5643 Spare
4 115 OPEN PLAN WORKSTATIONS phone unit no
ext. Spare
4 116 OPEN PLAN WORKSTATIONS
4 117 OPEN PLAN WORKSTATIONS
4 113 OPEN PLAN WORKSTATIONS
4 114 OPEN PLAN WORKSTATIONS 5643 Spare
4 115 OPEN PLAN WORKSTATIONS phone unit no
ext. Spare
4 116 OPEN PLAN WORKSTATIONS
4 117 OPEN PLAN WORKSTATIONS