We have developed a system in Access 97 which links to tables on a SQL Server database. On the developers machine (windows 2k) we set up a system DSN to connect. We set up the same DSN on a users machine (windows 2k) and gave him the same permissions as the developers have on the server side and his local machine.
Despite this, we get an ODBC error stating that SELECT request has been denied on all tables.
The DSN is set up to log in as the SQL Server dbo for the database.
Any ideas?
