I have a query which updates a table but when this happens the primary keys are removed. Is there any way in which i can reset the primary keys.
I have tried the following code:
But this only sets the key on the 1st column. I need to set the key on the 1st 2 columns.
Is there a way this can be done?
I have tried the following code:
Code:
Docmd.OpenTable "DML Initial Stock",acDesign
Docmd.RunCommand.acCmdPrimaryKey
But this only sets the key on the 1st column. I need to set the key on the 1st 2 columns.
Is there a way this can be done?