I don't think I am the first person to ask this question....but is it possible to insert the results from a stored procedure from SQL Server into a table in MS Access?
Thanks for the help but now I have to ask where or how do I store the password. I look at using a pass-through query but there has to be a better way then that. Any ideas?
I'm very new to SQL Server. I have just installed it and setup a few tables. I've created a new login using Sql Server Authentication. Now I have set up an ODBC connection to use in Access 2000 to the SQL Server and the connection tests successfully. But when I go to open the table in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.