Connecting Tech Pros Worldwide Help | Site Map

Can't Update an Updatable Recordset

  #1  
Old November 12th, 2005, 10:04 PM
Bob Darlington
Guest
 
Posts: 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


  #2  
Old November 12th, 2005, 10:04 PM
Bob Darlington
Guest
 
Posts: n/a

re: Can't Update an Updatable Recordset


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" <bob@dpcmanAX.com.au> wrote in message
news:406b806b$0$25655$afc38c87@news.optusnet.com.a u...[color=blue]
> I am using code (simplified for this post) to generate a recordset to[/color]
which[color=blue]
> 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
>
>[/color]


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with SELECT in UPDATE Statement Mikle answers 1 April 20th, 2007 04:05 PM
Help with complex single-table UPDATE query Slower Than You answers 3 November 18th, 2006 01:55 PM
missing records from coded recordset when compared to qbe Jan answers 13 November 13th, 2005 09:58 AM
Can't Update an Updatable Recordset Bob Darlington answers 1 November 12th, 2005 10:31 PM