calling stored proc

[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

 

[Dirk Goldgar]

Hi,

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

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.