Ms Access to SQL Server passthrough query
Posted on 2014-01-15
I have a strange situation. I created and access app that connects to an SQL server via recordsets and passthrough queries.
it works fine on two pcs within the organisation with no problems at all, but on the other pcs it only updates the SQL tables via the recordsets but if i try to run a passthrough query or exectue a store procedure via the recordset it fails.
i am using the same sql ID and password with all PCs (the two that work and the others that fail)
I am thinking this is a permission issue but I do know what permissions to grant on the server given the sql ID works fine with 2 pcs.
can someone shed some light on this?