select a unique record identifier for linked tables

[TonyLackey]

Hi,

I use access as a tool to manipulate data and then update our master database (Sybase).

When selecting tables in the first instance you can select the "unique record identifier" and Access will allow you to update the specific data happily.

If i send this database to a collegue in a different office, even if they use an ODBC with the same DSN, Access quite often loses the "unique record identifier". Access then gives the following error when trying to run an update query "Operation must use an updateable query!).

Apart from re-linking the actual tables and selecting the correct unique record, is there a method in Access to re-set these manually? (I know you can assign the key, but this doesn't work for linked tables)

Any help would be appreciated as it would simplify my instructions to my collegues (most of which don't use access on a daily basis).

NOTE:-

Why send instructions to none access users?
I'm posting a solution that literally saves days of work and increases accuracy on evry implementation we carry out. The post is displayed on our solutions intranet, thus giving everyone access to it...... I can't write code, but can use Access fairly well.

Thanks in advance.....

 

[TonyLackey]

Unique record identifier

Pat,

Thanks for you r help with this matter, i used the
ALTER TABLE routine to solf my problem.

Thanks for your help, it's appreciated

Cheers

Tony