Windows Forum

Ask something
Discussion Locked

Permission issue

0 helpful
2 replies

by edudley

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

I have a Windows xp with all the latest patches that will not let me access the SQL with any other than the domain admin user id. I have Access 2000 installed and can only see the database if I am logged on as the Domain Admin. I can go to another pc and log on as a plian domain user and make the database connection through Access. Both PC's are in the same domain and IP segment Its like the permission on this machine are not reacting correctly.
Would love any help. Don't want to have to reinstall the machine.
Thanks

2 replies

by brandon.aiken

I'm not sure I understand. Is it SQL or Access? What error message do you get, if any? How exactly do you connect to the database?

SQL uses the MDAC drivers, which can be updated to 2.8 SP1 from Microsoft. Make sure the ODBC connection to the SQL database server is correctly cofigured. Make sure that users have access to the database if they authenticate to it, and if the database connection is a User DSN you need to re-create it for every user on the system.

Access uses the Jet database engine, which should be at 4.0 SP8. Again, this can be downloaded from MS. Access databases are usually accessed through network shares. Make sure your users have correct share acess and NTFS access to the database file.

That's all the help I can give... your question is too ambiguous.

This discussion is closed to new replies.