Unable to edit imported tables linked in access

[SadOldGoth]

Hi Folks,

Apologies if this is the wrong forum, but I think it relates to the import through DTS.

I've imported a set of tables from an access database and set up all permission to edit, etc, yet when I link to these tables through access, I'm unable to edit the contents of the tables. However, if I create a table in the sql database and then link to it, I can edit the contents.

Hmmmm....

Is this something I should be aware of?

Thanks for any assistance.

Jes

 

[SadOldGoth]

Hi Folks,

It's ok, I've solved the problem - you must add a primary key to each table that you want to edit.

Later,

Jes