Select Unique Record Indentifiers

[Keyur Shah]

Hello,

I am trying to upgrade from Stoneedge 5.9 to 7.05 and am encountering requests in Access to select Unique Record Identifiers for each table.

This is occurring for many tables, such as

AddressesEnt

AttributesEnt

EmployeesEnt

Dazzle

....

Is there a list somewhere of which fields should be selected?

Thanks.

[Barney Stone]

That happens when tables in SQL Server don't have a "primary key" index defined. You can just press ESC for each of those tables. It's a nuisance, and unfortunately some of the otherwise fine custom programmers who work with Stone Edge never bother to create the primary keys on their custom tables. If you need to switch stores or re-link SQL tables frequently, you can go into SQL Server and add the primary key indexes to those tables, and that will eliminate those messages.