Hello – I’m connected to a Microsoft Access database where I can “move next”, “move last” etc., but when I try to add or delete I get this error: Object or provider is not capable of performing requested operation - 3251. Can anybody help me?
Printable View
Hello – I’m connected to a Microsoft Access database where I can “move next”, “move last” etc., but when I try to add or delete I get this error: Object or provider is not capable of performing requested operation - 3251. Can anybody help me?
What are your CursorType and LockType set to? You might need change them to be able to update, add, delete.
This type of error can have various causes depending on your method of access.... DAO, ADO... or method of access... dynamic, snapshop..etc....
It would help to see the code used to create the connection and to opent this recordset
Try using the Microsoft Jet 4.0 OLEDB Provider...