Recordset is not updatable

[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.

 

[MacDermott]

If the read-only property of the MDB file is set to True, you cannot update
data in the file.

HTH
- Turtle

 

[Adrian Jansen]

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