Create a pass-through query which executes the sp, as in:
Exec sp_myspname @param1='blah blah'
Simply create a query; don't add a table; select the Query menu, SQL
Specific, Pass Through; enter the above statement (adjusted for your values)
in the query, and save.
You can then execute the pass-through query just as you would another query,
using Currentdb.execute, or Docmd.RunQuery.
If you store the password in the ODBC connect string (in Query Properties),
then the user won't get prompted for it each time.
Neil
"EV" <er***@village.gurnee.il.us> wrote in message
news:4c**************************@posting.google.c om...
Can a SQL Server stored procedure be called from Access? If so, how
does one do this? and can it be "linked" to a button on a form?
Thanks
Eric Venden
Village of Gurnee