AS400 iSeries Access Unique Index for Windows Access
Posted on 2011-02-18
I would like to use Windows Access 2010 to modify an AS400 Physical File.
The AS400 file has No Key and no combination of fields will create a Unique Key.
I can access the file using iSeries Access using a Linked Table ODBC Connection.
Is there any way to create a logical file on the AS400 with a unique key or
create a psuedo unique key in Windows Access in the link.
Without a unique key the file cannot be updated in Windows Access