I have a very basic query that Access 2000 will not allow to be
updatable. I've gone through all the situations in the help file
where data cannot be updated, and I don't see that this query belongs
to any of those. I have checked all permissions, locks, etc.. - can't
find anything out of the ordinary that would explain it. Deleted the
DistinctRow - no change. The SQL version is below - anyone notice the
problem or have any suggestions? I'm sure it's something
simple/stupid, but, geez... I've already spent too long on this.
Thanks!
Martin Lacoste
(what it does - find where [incipit] field differs when [ID] field is
the same in both tables)
SELECT DISTINCTROW [Index]![Incipit], MASTER.Incipit, MASTER.FullText
FROM [Index] INNER JOIN MASTER ON [Index].ID = MASTER.ID
WHERE ([Index]![Incipit]<>[MASTER]![Incipit])
ORDER BY [Index].Folio, [Index].Sequence;