Re: Help - "this recordset is not updatable"


salad wrote:
ZRexRider wrote:
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

Have you gone to
http://groups.google.com/advanced_search?hl=en
and entered
recordset not updateable
in the All words box and entered
*Access*
in the Groups box yet?

It does sound workstation related but still a security issue. What are
the sql privs the workstations have. Are the workstations identical.
It sounds like its the workstation privs not the user privs.
However....

Do you have both sql and access security involved? If so, it could be
the access sequrity file that is stoping it on the workstation not the
sql security at all. This sequrity in access is held in the
system.mdw. Try creating a new system.mdw via workgroup administrator
under tools security. This will disconnect the existing security and
create a new empty access security on the workstation.

good luck

.

Relevant Pages

  • Re: Help - "this recordset is not updatable"
    ... It sounds like its the workstation privs not the user privs. ... Do you have both sql and access security involved? ...
    (comp.databases.ms-access)
  • Re: Help - "this recordset is not updatable"
    ... It sounds like its the workstation privs not the user privs. ... Do you have both sql and access security involved? ...
    (comp.databases.ms-access)
  • Paradigms II
    ... Secure Systems Revisited ... Performing the following very basic security evaluation on your system ... (server or workstation); however, they can be easily adapted to any other ... control over that information. ...
    (comp.security.misc)
  • Re: Paradigms II
    ... > are not about trying to circumvent security. ... > (server or workstation); however, they can be easily adapted to any other ... > to have at least a vague idea what security, and a secure environment, ...
    (comp.security.misc)
  • RE: SQL Slammer doing the rounds again?
    ... SQL Slammer doing the rounds again? ... "I used to hate writing assignments, ... > Security Business Unit ... > at the largest, most highly-anticipated industry ...
    (Incidents)
Loading