800a0cb3 current recordset does not support updating dinner dating herts
Heya all, I have looked through the forums, and have not been able to find an answer to my problemn, so thought I would let the experts have a look at the code, to see where the problem is coming from.
Open "Provider=vfpoledb.1; Data Source=C:\ebilitydata\; Mode=Read Write|Share Deny None" cn MSAccess.
I have setpped through the code, and the open works, and everything looks ok, but...... You are not adding the last 3 arguments to the rs EBMaster. By not providing them you are opening a forward-only read-only recordset which doesnt support updating. If the Source argument is a select statement then you use the ad Cmd Text argument. Use ad Open Keyset if you are not in a multiuser environment and use ad Open Dynamic if you are and need to see other users inserts and deletes rs EBMaster. The if.command bypasses every single record, even though it finds records. However, I still get the current recordset error message when trying to assign the value to the field I appreaciate all your help to this stage.
Update line I get the error "Recordset does not support updating". ad Cmd Table is specified only when the Source argument is a table name only as in opening the entire table. Okay that is slightly better as it now processes the if.routine.
Close Unload Me End Sub When the program gets to the . What about the feasability of using a SQL INSERT command instead of the way that I am doing it?
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
Value & "'", cn Ebility, ad Open Dynamic, ad Lock Optimistic, ad Cmd Text Msg Box rs EBMaster("ISBN").
Open "select isbn, location from master where isbn = '" & rs MSsb("ISBN").
Open "select master.isbn,master.location from master where isbn = '" & rs MSsb("ISBN").
This may be a limitation of the provider, or of the selected locktype.