Linking

[Peggy]

I have created an Access database for inventory control. It is linked to a AS400 database. The problem is after linking it doesn't recognize the properties. Example: Required is "Yes", Indexed is "Yes (No Duplicates). It is not acknowledging the commands. I am trying to write a code on the form to prevent duplicating on 3 different fields. NO LUCK. All my books just refer to setting this up in the table. I need to set it up in the form. Sure hope you have an answer.
Thanks!

 

[Pat Hartman]

These rules need to be defined in the database on the AS400. The ODBC driver may not properly display certain attributes of a table, but the backend RDBMS will not accept updates that violate any data integrity constraints that were defined for it.

 

[Peggy]

I thought I could could write a code in the form (VB) to show a msgbox when there are duplicates. Have you ever done that before? If so, please tell me how.