Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

share|improve this answer

Your Answer


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.