Interesting I found this at
loading-a-recordset-at-57970.html
SELECT * from tablename
WHERE primarykey = (SELECT MAX(primarykey) FROM tablename)
which I have previously used with an access db
Seems to work with MySql. Do you think its OK to go that way?
Thanks
John