MS SQL Sever to MS Access Front end linking of editable queries
Posted on 2012-09-04
I am trying to create a link between MS SQL Server (2005) and Access (2010) with the use of editable queries. I have researched how to use pass-through queries and stored procedures with parameters, however they both return an error that does not allow me to edit the data-set that was returned.
Is there any way to populate a data-set that is updateable in an Access front end with a SQL Back end while using parameters? If so, what is the best way to do it? Is there an example?