I have a linked SQL table and I moved it from a sql server that was local to the machine access was running on to a stand alone sql server.
Since then my stored procedures wont run. The procedure runs if I run in management studio but doesnt when I run it from access. I am using the same system DSN to connect the query to the database that i used to connect to the table.
I can see the data in the table but not run the stored procedure.
Is there some special permissions I need to give or something?