using forms to edit table

[jrb1024]

I have a problem. I currently have files from our AS400 linked to access through OCBC. I am not able to edit or add any fields to the file through the form or table feature in access. The permissions on the AS400 are set correctly, is there something to change in Access?

Thanks for the help!

Josh

 

[boblarson]

You can't add or edit fields in tables that are linked. You can modify tables local to the Access database, but you can only add or modify DATA through an ODBC connection (and it varies as to which you can actually write data to as some are read-only).