This may be a limitation of the provider, or of the selected locktype.
OLEDB.4.0; Data Source=C:\Documents and Settings\peterc. UBS\My Documents\db1.mdb; User Id=; Password=; Mode=Read Write|Share Deny None" 'Unload Me End Sub Private Sub Command1_Click() rs EBMaster.
Open "select * from completewarehouse", cn MSAccess rs MSsb.
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.
Open "master", cn Ebility, ad Open Dynamic, ad Lock Optimistic rs MSsb. Open "select master.isbn,master.location from master where isbn = '" & rs MSsb("ISBN").