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.
 
If the read-only property of the MDB file is set to True, you cannot update
data in the file.

HTH
- Turtle
 
You create a query with clause "WITH OWNERACCESS OPTION" , and show just the
field(s) you want the users to be able to edit. Then they can edit using a
form based on that query.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top