remove read-only status

[Cooz]

Hi everyone,

When I try to run an Access application that I placed on my standalone
laptop, somewhere along the way error 3027 "Cannot update. Database or object
is read-only." pops up.

I discovered that this happens in the VBA line
rs.Edit

This line is preceded by
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Qr1 WHERE " & criteria$)
Do While Not rs.EOF

Qr1 is a query that contains about six tables; criteria$ is a string that
correctly complements the SQL statement. The network version of the
application doesn't have a problem with these lines of code anyway.

My question is: what exactly can have become read-only; how can I check this
and how can I make it read-write again? When I right-click the tables that
take part in Qr1, I cannot find a read-only attribute under 'Properties'.

Thank you,
Cooz

 

[Cooz]

You all can stop searching...

By adding the dbOpenDynaset, 0, dbOptimistic parameters to the rs
definition, I obtained a read-write recordset. Ha!

Microsoft documents this in kb article 209943, which applies to Access 2000.
I use Access 2003. An update would be nice.

Cooz