I ran into this problem when I upgraded from Win XP Pro to Win 7 Pro.
I created System DSNs using admin permission. Those DSNs are supposed to be visible to all users. However they were not visible when I tried to created linked tables in Access for a non-admin user. On the Access screen to select ODBC DSN, I could only see two tabs, File DSN and Machine DSN. Under Machine DSN, I can see all DSNs from the User DSN tab where DSNs are created. Those DSNs under System DSNs (in creating DSN screen) were nowhere to be found.
I think Win 7 Pro made some changes to enhance security. Any advice to make those System DSNs visible to all users?
Thanks.
I created System DSNs using admin permission. Those DSNs are supposed to be visible to all users. However they were not visible when I tried to created linked tables in Access for a non-admin user. On the Access screen to select ODBC DSN, I could only see two tabs, File DSN and Machine DSN. Under Machine DSN, I can see all DSNs from the User DSN tab where DSNs are created. Those DSNs under System DSNs (in creating DSN screen) were nowhere to be found.
I think Win 7 Pro made some changes to enhance security. Any advice to make those System DSNs visible to all users?
Thanks.
