Giving views a unique identifier

[MarkGreen]

Hi, i'm having trouble allocating a unique identifier on a view.
I am importing SQL server views into access as tables, but every time i (or any user) connects to the server, I get a message asking the user to select a unique identifier for each view individually. This is obviously not practical to have every time but i cannot find a way of getting round it!!
Any help is greatly appreciated!

Mark.

 

[harryrich]

You will likely find your solution at the client end.

Access 2000 serves for the client at this site. It asks for a unique identifier when an SQL Server table is first connected to a database but the database retains that information and does not normally ask for it again.

The protocol here is to make sure the first field in any view will serve as a unique identifier, and to instruct users to select that field when prompted for a unique identifier.

Best,

Harry