Connect with Access

Can someone point me in the right direction.. I want to connect to and call
either a procedure or function from accessYou can add a linked server to Access from SQL Server. For examples, see
sp_addlinkedserver, and sp_addlinkedsrvlogin in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Brian" <nixtootec@.hotmail.com> wrote in message
news:edIFt3k#DHA.2324@.tk2msftngp13.phx.gbl...
Can someone point me in the right direction.. I want to connect to and call
either a procedure or function from access

Connect with Access

Can someone point me in the right direction.. I want to connect to and call
either a procedure or function from accessYou can add a linked server to Access from SQL Server. For examples, see
sp_addlinkedserver, and sp_addlinkedsrvlogin in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Brian" <nixtootec@.hotmail.com> wrote in message
news:edIFt3k#DHA.2324@.tk2msftngp13.phx.gbl...
Can someone point me in the right direction.. I want to connect to and call
either a procedure or function from access