Someone more knowledgeable than I may have an asnwer – they may need to know
the versions of Access and your AS/400. — here’s what I know.
I haven’t found a request from the AS/400 side.
The newer versions of Access tables can be addressed through an ODBC connection.
I’ve connected from early versions of access to the AS/400- and I’m sure this still works.
install client access on the machine
create an ODBC data source to the AS/400
create remote tables — that are 400 tables
use/update the tables from within access