General discussion

Locked

ODBC Problem Access 97 to SQL Server 2K

By munrrob ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Curacao_Dejavu In reply to ODBC Problem Access 97 to ...

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

Collapse -

by munrrob In reply to

Poster rated this answer.

Collapse -

by munrrob In reply to ODBC Problem Access 97 to ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums