Setting key in a Linked Table

[Guest]

I need to set keys in a linked table. I had set the keys when I orginally
linked the table but now I need to add another key to the list. I keep
getting an error.

Any help would be appreciated.

 

[John Vinson]

I need to set keys in a linked table. I had set the keys when I orginally
linked the table but now I need to add another key to the list. I keep
getting an error.

Any help would be appreciated.

Open the database which actually contains the table, and make the
change there. It's safest to delete and recreate the link from the
frontend after you have done so.

John W. Vinson[MVP]

 

[Guest]

I am not able to do that as I am connecting to an AS400 through ODBC.

 

[John Vinson]

I am not able to do that as I am connecting to an AS400 through ODBC.

You may be able to use a DDL (Data Definition Language) query as a
pass-through query. I'm not well versed in AS400 so I'm not sure just
what would be involved, but you would certainly need the appropriate
database modification privileges.

John W. Vinson[MVP]

 

[Rick Brandt]

I need to set keys in a linked table. I had set the keys when I
orginally linked the table but now I need to add another key to the
list. I keep getting an error.

Any help would be appreciated.

CurrentDB.Execute "CREATE UNIQUE INDEX IndexName ON TableLinkName(FieldName1,
FieldName2);"