|Posted: 11 October 2004 at 4:09pm | IP Logged
Marty Connelly came across this introductory article complete with sample mdb's that some may find useful for SQL Server or MSDE.
How to Execute SQL Stored Procedures from Microsoft Access
The simplicity and popularity of SQL Server means that more and more developers who build applications with Microsoft Access will want to learn how to take advantage of server side processing using SQL Server Stored Procedures. In this article, Danny Lesandrini demonstrates a simple method for executing procedures from Access 97 and Access 2000.
This method uses SQL server password authentication rather than windows.