Solved

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

Posted on 2011-03-14
3
362 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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 …

932 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now