up vote 0 down vote favorite
share [g+] share [fb]

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 (-: )

link|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
feedback

2 Answers

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.

link|improve this answer
ODBC, I believe! – billynomates Oct 14 '10 at 12:19
feedback
up vote 1 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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