how do I Select Unique Record Identifier when linking views using code

[Keith G Hicks]

I have an MS Access 2k front end connected to an MS SQL 2000 back end.
All of my tables are indexed appropirately and they link and are updateable.
I have a view that I need to link.
When I link it manually, I can select the field that makes the recrod unique
when the messsage "Select Unique Record Identifier" pops up.
But I do most of my table/view linking in code. Since my tables are indexed
on the back end, they work fine. But the view is not indexed on the back
end (I already walked thru that nightmare and was not successful because of
several roadblocks I don't want to overcome right now).

So the question is, how do I handle the "Select Unique Record Identifier"
when I link the view through code in the front end?

Thanks,

Keith

 

[Keith G Hicks]

Never mind. I found it. This works:

Run this in a query window:

CREATE UNIQUE INDEX index1 ON SeptemberOrders (OrderID)

REF:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209123&Product=acc2000

 

[Rui Almeida]

Hi

I have the same problem linking a table thru code but,
instead of SQL Server, i connect to Oracle 8i. The
message "Select Unique Record Identifier" pops up but, i
dont need to create a unique record because there is no
need of record identifiers.

Thanks
Rui Almeida