By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

Can't Update an Updatable Recordset

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Please disregard my earlier post. Problem was a simple omission on my part
(which was not reflected in the code snip I posted),

--
Bob Darlington
Brisbane
"Bob Darlington" <bo*@dpcmanAX.com.au> wrote in message
news:40***********************@news.optusnet.com.a u...
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.