Stored Procedure not found

M

Mark

I am using Access 2003 / SQL server 2000 for an access project that I have
installed on a users computer. I am using the run-time version of access on
this computer(user does not have access installed). Anyways on my computer
where I develop the program I created two stored procedures that copy records
from one table to another and then deletes the records from the origin table.
I then set up a macro that calls these two stored procedures. For some
reason when the user clicks the button that runs the macro, an error message
appears that says the spAppendDrafting could not be found. Is there a
limitation that ade files have when running on a run-time version? I have
verified that this user has the appropriate rights to execute these two
stored procedures. I am at a loss. By the way, this is the first stored
procedure that I have used in my application so far.
 
Top