Cannot change table

[racer514]

I have a table in an access/sql database that I ususally
can change data in when necessary. It is an ODBC connection and it's just this one table that I need to change data in quite often. Currently we just change the data manually untill the dev team develops a more proper way to do it.
The other catch is that I can change the table on some machines and not others, regardless of user id. I have re-done the link table and nothing changes. It is totally abnormal.
Any ideas would be appreciated due to my lack of experience with databases.

Thanks in advance.

 

[japyy]

Probably no ODBC made on the other machines, check the machine you want to work with.

 

[racer514]

Bare with me, my language is quite beginner.
I have a good ODBC connection on my machine (the one I am having trouble with) and the same connection on th e other machines to the database.
Didn't quite get what you were saying.

 

[japyy]

Well, I'm not that much of an expert myself. Anyway, when I had a problem like yours I found that it's worhtwhile to make a new ODBC on the machine you´re using, but first check if the same driver is used on different machines. (you'll find version-numbers on another tab in your ODBC screen) Then link the table again.
Good luck, hope you'll find a real expert if this doesn't work out!

 

[racer514]

NowI'll make ya feel like an expert compared to me but what do you mean "driver" and where would I see if they are the same or different.