Select Unique Record Identifier programmatically

[MikePS]

I want to programmatically link a SQL view which needs to be updatable. If I do it manually I get the Select Unique Record window, select the unique ID field, and get an updatable linked view. But if I link it programmatically (using the CreateTableDef method), I don't know how to set a unique record and thus I can't update the view.

I found a post from several years ago, thread 700-1012976 (Feb 05), where dhookom alludes to a way to do this, but didn't spell out exactly how. I'm sort of a newbie, so I need pretty concrete suggestions!
TIA, MikePS

 

[dhookom]

You may be able to use a Data Definition query like:

CREATE UNIQUE INDEX NewIndex 
ON Friends ([LastName], [FirstName]);

Duane MS Access MVP
Now help me support United Cerebral Palsy