I've been reading the newsgroups and most of the solutions for this
message are simple and obvious but unfortunately don't solve my
problem.
I have an MS-Access 2002 ADP application that connects to SQL server.
The application is deployed to 100+ users and in most cases works fine.
I have a sub-set of users (~20) who have an auditing function. They
review transactions entered by the other 100+ and accept or reject
them. There are a few fields that these auditors are allowed to
change. However, there are a number of users in this sub-set who are
unable to edit these fields. If they attempt to change that status bar
displays "this recordset is not updatable".
It seems to be MS-Access/workstation related. If I have the user (who
has problems) log into the PC of a user who doesn' t have this problem
using their own logon credentials it works perfectly. If I reverse
that - have a user who has no problems editing this data log on to a
workstation where the user is having problems - they find that they
cannot edit the data either. So in my mind it doesn't have anything to
do with user rights, the recordset or my code since it's the same
recordset, same database, same code no matter who runs it.
I've been comparing Access versions, service packs, DLL versions....
and I'm not finding anything obvious. Does this ring any bells with
anyone?
Thanks