Access Link through ODBC

  • Thread starter Thread starter brett
  • Start date Start date
B

brett

Hi all,

This may not pertain to programming, but im trying to program using the data
(that i can't seem to access.) I created a link through access to our
accounting tables on our server. I have no problem accessing AND editing the
tables as administrator, but there is a second user (who is part of the
administrators group) that can view but can't edit the tables. When she
attempts to edit the tables she receives the following error:

[TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Access
denied. (# -1907)

I don't understand what the difference could be between these two accounts.
Any thoughts??

Thank you!
 
1. Is it computer-specific? Can you edit from her computer, and is she
blocked on yours? If so, perhaps it is in the DSN setup.
2. See if there are ODBC-specific user-specific security settings in the
back end DB. I know that some DB platforms allow editing but can explicitly
deny editing via ODBC connections.
 
Back
Top