This recordset is not updatable

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a database that is read only to most users. I
would like them to update one field in a table when they
are in it. I tried to update the field in code and it
does not work. Does anyone have a work around or is read
only, just like it says read only.
..
 
What do you mean by "read only"? Is it a file attribute or have your
implemented User Level security and allowed them Read Only access to the
table? If the file attribute has been set, I don't know how you would get
around that in code ... if they are restricted by UserLevel Security, then
you can open a Workspace with the credentials of a user who DOES have
permission to read/write to that table and run an Update query. There's a
good example of doing this in the Visual Basic help section of Access (for
the VBA code window help command, search for "Workspace")

The drawback to doing this, of course, is that unless you have restricted
users from viewing code (and you should have), then any curious user could
easily snag the user/pass of an Admin user. Not sure if that applies in your
case or not ....
 
Back
Top