Web Development

Ask something
Discussion Locked

ODBC Problem Access 97 to SQL Server 2K

0 helpful
3 replies

by munrrob

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by curacao_dejavu

download the new mdac at http://tinyurl.com/iza5

install the mdac on the local pc as the local administrator.
configure the odbc first as the local administrator and test it.
Then login as the user and check it as the user.

the problem is his user rights are different user , instead of power user or admin. and in the registry keys his permissions are not correct.

If not it's on the sql side.

Leopold

Leopold

This discussion is closed to new replies.