Error Cannot update. Database or object is read only. --- can I clone the dao recordset

[Henners]

Hi,


I have an Access DB linked to MSSQL.
I am using a DAO.Recordset to hold my data, which comes from a View. I can understand that I am unable to update the recordset because it is a view.
I would like to create a clone of the recordset and then use the clone to hold my changes but not commit those changes to the database. I will then use the clone in another process to add new records to another table.
Does anyone know how to create a clone that will not keep the read-only properties, so I can update it?

Also, I know it is possible I am sure I had to do this on another project 2 years ago for a company I worked for. But can't remember

[Henners]

Sorry to bother all fixed.
Using this guy's function http://www.vbforums.com/showthread.p...13#post2263813
I created an ADO recordset with a ADO recordset that does not keep the readonly properties.

[June7]

According to Wiki a view can be defined as read-only or updatable.

AFAIK, updating a RecordsetClone updates the underlying data source.

Create records in table then edit them.

Why do you need to replicate data to another table?

[isladogs]

Not a direct answer to your question but a different solution

SQL views CAN be updated in Access providing
1. The view is updateable in SQL Server
2. A primary key field is assigned to the view in Access

Point 2 applies to any update query in Access. Even for local tables, a PK field is required

How you assign a PK field will depend on how the view is linked in Access -ODBC or DSN less connection string

[pbaldy]

Post 2 was moderated, I'm posting to trigger email notifications.