Solved

Need help creating a Sql Stored Proc and executing it from Access

Posted on 2011-03-14
3
372 Views
Last Modified: 2012-05-11
I have an access front end linked to some tables in a Sql Server 2005 back end.  I would like to create a stored procedure in Sql Server that appends all records from Table 1 into Table 2.  I then need to be able to execute that Stored Procedure from my Access front end.  My access front end is linked to Table 2.  I have never done this before and need some help with the sp syntax and how to call it.   Thanks.
0
Comment
Question by:snyperj
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
viscogel earned 500 total points
ID: 35127755
0
 

Author Comment

by:snyperj
ID: 35129814
hmmm... i created two stored procedures.  One to delete all the records from my temporary table and then one to append new data into it.    I am then calling them from a pass through separate pass through queries using 'exec' and the sp name.

I can delete records from the table ok... (So I am able to "exec" from the access side...)  however whenever I try to run the sp that appends new records I get the error shown.

If I run the sp from SQL, it runs no problem and quickly.
error.jpg
0
 

Author Closing Comment

by:snyperj
ID: 35133186
worked through it... thanks for the link.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question