Running a stored procedure from Access form

V

Vadim Pokotilov

Good morning,

I've built an "edit record" form. The controls are all unbound, and are
prefilled with the existing data using a recordset that's opened from a
stored proceture [rst.open("exec ...")]

The "save" procedure in this form uses a different stored procedure to write
back to the table. First I build an arguments string based on the values of
my form items, then I execute DoCmd.RunSQL("exec ..."). Unfortunately, when I
do this I get the error: "There was a problem accessing a property or method
of the OLE object". How can I get this to work?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top