By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,833 Members | 2,071 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,833 IT Pros & Developers. It's quick & easy.

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

P: 4
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
Oct 2 '07 #1
Share this Question
Share on Google+
3 Replies


P: 4
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
Oct 4 '07 #2

Scott Price
Expert 100+
P: 1,384
Glad you figured it out, and thanks for posting back with what worked!

Regards,
Scott
Oct 4 '07 #3

P: n/a
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!
Oct 6 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.