Hi, I have this situation:

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:
"ODBC;DRIVER=SQL Server;SERVER=king;UID=;PWD=;DATABASE=OSADATA"

Thanks, Adrian