Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkrishna
Starting Member
23 Posts |
 Posted - 2010-05-17 : 08:37:58
|
| I have a test database on SQL 2008 Express and a front end Access 2007 application linking the tables with this database. I can create the SQL queries in the Access to generate reports in Access.I created a stored procedure sp_GetMetrics in the SQL Express server. This involves some calculations with user functions also created in SQL.I want to run the stored procedure in Access as an SQL query. I tried to use the RunSQL action query with the SQL statement, but it does not work. Will any of the experienced database specialists with similar setups advise me how to go about this procedure?Thanks in advance |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Run a Stored Procedure in Access front end...