Cannot found System ODBC DSN when linking tables

[seaport]

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.

 

[genomon]

Try right-clicking Access and select "Run as Administrator".

Gluais faicilleach le cupan làn