Hi, I have an AccessADP connected to SQL Server 2000. I have a view joining
two
tables on a straight forward inner join... SELECT dbo.tblStopInformation.*,
dbo.tblLinesStops.Sequence, dbo.tblLinesStops.LineID,
dbo.tblLinesStops.LineStopID
FROM dbo.tblLinesStops INNER JOIN
dbo.tblStopInformation ON dbo.tblLinesStops.MetlinkStopID
= dbo.tblStopInformation.MetlinkStopID
WHERE (dbo.tblLinesStops.LineID = 2579) If a field value is modified in the
query the record changes to a different record WHERE (dbo.tblLinesStops.LineID
DOES
NOT EQUAL 2579) !!!! Sometimes it happens, sometimes it does not!!! If I
requery/refresh
the view the correct data is displayed (including the field updated with the new
value). Does anyone know why this is happening??????? I've spent 2 hours trying
to find the cause but found nothing. Thanks, Angelo
