Hi folks,
I am access a file on an AS/400 using ODBC. I can access the file with
no problem, but whenever I try to update a record I get a "Record Not
Available" error. Any Ideas why? Thanks.

You may need to provide access rights to a journal file on the AS/400 side.
OR you can go to Global Properties, File Control and disable the RI
Transaction frame setting. The TopSpeed AS400 docs mention journalling
somewhere.

John

John, my sympathies!
Make sure you have a unique, primary key on table. I am not sure if this
applies any longer, but I found that including the key on the FILES section
of the update form also helps.

This will result in a correct SQL where clause for the update. Be *very*
careful about deleting records where you do not have a unique, primary key
on table. This could result in dangling members (orphans) and lots of
deletes you don't want.

--
Best regards
James Cooke
Certified Clarion Developer