I have a SQL table in which I need to update selected records. But, by design, there is no key field in this database and it would be difficult to establish a key field. Since there is no key field I have noticed the Access table listing has table edits (changes and deletions) greyed out. So, there is no way to issue an Update command.
However, I know it is possible to update or delete the record(s) because I can write and execute a query using the SQL Query Analyzer or the Enterprise Manager.
So, my question is, is there some control or property I can set that will enable Access to update or delete records using an ODBC connection when there is no key field?