I am using code (simplified for this post) to generate a recordset to which
I want to add a record.
Set rs = db.Openrecordset("SELECT * FROM qVariations WHERE ......")
ws.Begintrans
If rs.Updatable then
rs.AddNew
rs!LAN = vLAN
rs.Update
etc
The fifth line generates Error 3027 (Cannot Update. Database or Object is
read only).
The query (qVariations) can be manually edited.
I am using A2002.
I would have thought that the Updatable test would identify any problems.
Any help appreciated.
--
Bob Darlington
Brisbane