"Tom Harris" <TomH at optiscan.com> > SELECT TOP 1 * FROM tbl > ORDER BY id DESC Yes I am aware of that, but it can give me conflicting writes. But ok it's a low write-volume database, and will stay that way, so it will probably work ok. regards Max M