We recently updated our database from sql server 7 to sql server 2005. We use access as a frontend for our main application which exists on a terminal server.
When I log into the terminal server as an admin and open the application; the stored procedures work fine. When I log in as a normal user most of the storedprocedures fail. Also when I am logged in as a user access renames the stored procedures and adds a ";1" at the end of them or adds a prefix of "fn" or "dt".
Obviously this is some sort of permissions issue, however we do not know where to change the permissions for this.