Re: Howto set Access Recordsource onto a "select" sproc
Posted by Stu on 09/30/05 03:52
Look at pass-through queries in Access; they'll run the stored
procedure on SQL Server. However, you'll have to use VBA to modify the
paramaters (by actually modifiying the text of the pass-through query).