Stored procedures in Access for SQL 2000

T

T

Hi,

I'm trying to execute a stored procedure from Access
forms, but I keep getting the following error...

Run-time error "2495"
The action or method requires a Table Name argument

The stored proc looks like this...
Docmd.Openstoredprocedure (delete_table), 1

The only function of the stored proc is to truncate a
table...

Tx!!
 

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

Similar Threads

Export Report with Graph to Excel error 2495 1
Execute SQL Stored Proc from Access 1
Refreshing Project Connection Using VBA 0
Making form based on stored procedure 0
Cannot show a resultset produced by a stored procedure 2
Stored Procedure "...did not return records" Error in Access 2007 2
Run a SQL Stored Procedure from VBA 0
how to pass parameters from forms to stored procedures 21

Top