Well, I have found the answer to my question.
When linking to an ODBC table for update in MS Access, the table must have an unique key. You must select that key on the last screen during the linking process regardless of keys established on the source system. I was not doing this because the table
is keyed on the source database. Silly me! Once I added the key through the linking process I could update with no problems.
Thanks to all who spent time pondering this issue!
NZ
Quote:
Originally Posted by nzaiser
Hello! This is my first time asking a question here, so please bear with me if I seem 'unconventional!'
My issue is this.....
OS: Windows_NT
App: MS Access 2000 (also in 2003)
ODBC linked table into a DB for which I have read/write/delete authority.
I have verified the authority in the source DB - ad nauseum - it works. Tested the table in question (Region) specifically and another table (Store_Info) as well.
I can open the Region table in MS Access. However, I cannot update fields within the table.
I can open the Store_Info table in MS Access. Here however, I can update fields within the table.
I have checked as many links as I can find through (Start/run/odbcad32) and within MS Access (linked table manager).
I recieve no error message - keystrokes simply do not register within the field.
I have looked at the security within MS Access and cannot find anything relating to table access authorization.
Can you suggest some areas I may have missed, please?
Thank you.
NZaiser
