calling stored proc

  • Thread starter Thread starter JPM
  • Start date Start date
J

JPM

Hi,

Access 2000 VBA:
Is there any way to call a stored procedure using DAO without using a SQL
pass-through query?

Thank,
JPM
 
JPM said:
Hi,

Access 2000 VBA:
Is there any way to call a stored procedure using DAO without using a
SQL pass-through query?
Click to expand...

I can't think of one. Of course it doesn't have to be a *stored*
query -- you can create a temporary querydef, set it to execute the
pass-through query, and then destroy it.

On the other hand, it's straightforward to execute a stored procedure
using ADO instead of DAO.
 
Back
Top