Composite Key for Relational Database Access 2003

[watermon]

Hello group,

I'm attempting to set up a relational database utilizing a composite key of several data fields. I had no problem doing this with FileMaker Pro yet with Access 2003 I'm having problems. For example, in Design View I select the field names needed for the composite key.

Yet when I click save I get a message "Microsoft Access can't save property changes for linked tables." As a result I'm not able to construct a composite key of the several data fields selected. Thanks in advance for any help.

[alansidman]

The issue you have is you are attempting to change the properties of fields located outside of Access. The tables are linked. If you wish to change the properties of the linked tables, you will need to import them into Access. Otherwise, you will have to change the properties (if you are able) in the tables in their native environment.