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 (-: )
From serverfault
billynomates
-
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.
billynomates : ODBC, I believe!From Brian Knoblauch -
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
From Kevin Ross
0 comments:
Post a Comment