Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an Access 2010 front-end to an SQL-Server 2008 database. I'd like to use the stored procedures already on the server via the front-end!

Is this even possible?

(Bit of a newb so go easy on me (-: )

share|improve this question
    
Just realised this may be in the wrong place! Should I try Stack Overflow instead? –  billynomates Oct 14 '10 at 11:29
    
SO is probably a better place. The answer actually depends on the type of stored procedure, whether it returns records, etc. –  David W. Fenton Oct 16 '10 at 15:44
add comment

2 Answers 2

up vote 0 down vote accepted

What kind of connection do you have? Does it let you pass T-SQL statements? If so, you should be able to just EXEC the sprocs... Unfortunately, I'm not familiar with Access, only SQL Server.

share|improve this answer
    
ODBC, I believe! –  billynomates Oct 14 '10 at 12:19
add comment

You can fire stored procedures using ADO. Below is a link to an article detailing exactly how to do it and also get the result back

http://bytes.com/topic/access/answers/205120-get-stored-procedure-output-value-back-vba

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.