General information
Title:
ADO in OfficeVBA to VFP DBC with Stored Procs
Sorry, I was not sure to post this in the VFP forum or the Office forum, but here it is...
I am using Microsoft Excel VBA and ADO to connect to a VFP6 dbc with stored procedures to calculate the primary keys.
Everything works fine until I try to create a new record through ADO with the recordset.addnew command. I get an error message that says the provider can not do that command.
Does anyone know of a workaround without going to a COM solution? I am not up on the COM learning curve, and would hate to postpone this project until that can happen.
TIA,
Dan Neuman
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only