SQL Server with one table. The table does not have a primary key because it has no unique data in any field. When I link to it with the wizard from Access, I can have 2 situations:
1. I choose a primary key (and it let's me even if it is not unique) - the data in resulting table link is read-write
2. I DO NOT choose a primary key - thae data is read-only
When I link from code, I get only the read-only result. I would like it to be read-write. Is there any way to ensure that when linking from code?
My connection string is: