Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Tools General

Has anyone tried "Using SQL Stored procedure in MS ACCESS"?

I am developing a program using ms access with an SQL 2000 back end. I am using an odbc connection to access my data. Using this connection, i can only access thetables and views of my database. I am planning to create "Stored procedure" in SQL and connect it to my MS Access program but have no idea how to do it.

Please help! Thanks in Advance!

[383 byte] By [areknee] at [2008-2-23]
«« Application Config (ini vs xml)
»» MSMQ (Messaging Queue)
# 1
Might I suggest an Access newsgroup as its an Access specific problem? SQL Server SPs should just be called like a SQL statement is executed, ie "exec usp_foo" instead of "select * from foo".
EuanGarden at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 2
if you want to view stored procedure from Access I suggest you to not use a Access Project (file .adp) instead of the classic Access database (.mdb);
in this way in the Query tab of you Access Project you will see views and stored procedure of the Sql server and then you can manage these directly by Access.
bye
r.cicca at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...
SQL Server
SQL Server Tools General

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified