Error invoking Macro for Passthough Query from Switchboard

B

blinton25

Hello,

I have a Passthrough Query:

CREATE PROCEDURE ClearInputTable

AS
delete from [input table]
GO

which I call using a macro. If I run the Passthrough
query from the Query window, or by double-clicking the
macro which calls the query, it works ok. However if I
run the Macro using the Switchboard Manager, I get the
following error:

Macro Name: ClearInputTable
Condition: True
Action Name: OpenQuery
Arguments: ClearInputTable,Datasheet,Edit
 

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