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

Recordset read only problem

P: 6
Hi all!!

I would greatly apreciate any help in this!!

I have problems with a recordset (it says that it is read only and I need to modify some of its values) and then I tried to create the simpliest version to see where is the problem. I keep having the same problem.

The simplest version is just:

Dim Rs2 As DAO.Recordset
Sql_Str = "SELECT 0 As Id, '' As Cod, 0 As IdOff, 0 as QToT, 0 as Pro, 0 As TotCost"
Set Rs2 = DBsa.OpenRecordset(Sql_Str, dbOpenDynaset)

When I try to modify any value in any field in any record in Rs2 ... it keeps saying that it is read-only.

Any idea about what happens and how to solve the problem??

Thanks a lot for your help!!!
Mar 18 '17 #1
Share this Question
Share on Google+
2 Replies


PhilOfWalton
Expert 100+
P: 1,430
The Obvious thing is that no table is defined.

Try building a straightforward query using the QBE grid, then copy it's SQL into your VBA project.

Phil
Mar 19 '17 #2

P: 6
Ep!!!!

So evident!! :-(

You can't update anything you don't have!!! :-(

Thanks a lot!!!
Mar 19 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.