Cannot update ODBC linked table even though I have R/W access to the table

[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

[nzaiser]

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

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

[Scott Price]

Glad you figured it out, and thanks for posting back with what worked!

Regards,
Scott

[Bill Forbes]

Thank you for posting this solution. After I found out my SQL user ID had the correct permissions, I guessed the problem was with the ODBC drivers or connection. So with my search parameters, voila! I found your solution and relinked my table with a unique key.
Problem solved. THANK YOU!