469,271 Members | 1,668 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Can't Update an Updatable Recordset

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
1 1254
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.

Similar topics

6 posts views Thread by Henry Bloom | last post: by
1 post views Thread by Just_Buy | last post: by
4 posts views Thread by cronept | last post: by
1 post views Thread by Bob Darlington | last post: by
3 posts views Thread by Michel Esber | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.