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 (-: )
Sql-server – Running a MS-SQL Server Stored Procedure from MS Access
microsoft accesssql serverstored-procedures
Related Topic
- Sql-server – SQL Server: Why is recompiling stored procedures required
- How safe is SQL Server’s encryption of stored procedures
- SQL Server – How to Dump Database to SQL Script
- Security – Configure user login and stored procedures permissions on SQL Server
- Sql-server – Automaticaly export Jobs and stored procedure from mssql server
Best Answer
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.