Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Access passing parameters to SQL Server

Author  Topic 

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2000-08-02 : 00:00:00
Bob writes "I use Access as a front end to SQL7. I currently use linked tables, but I would like to do more with pass thru queries. Many of my queries use date parameters that are grabbed from Access forms. Will Access evaluate these parametrs and pass the value to SQL Server or is this not going to work? Thanks for the help!"

That should work. If not, convert the dates to strings and pass them that way.
   

- Advertisement -