I have a problem as system DSN is not visible to 'domain users'. I know that such question has already been asked here and also to other web communities, I tried all solutions but still my db is not visible to all domain users.
I have created on Win7 machine a db with My SQL, it is my backend. As front end I use MS Access, linking tables to MySQL. I opted for such solution as most of end users are used to Access and they can create their own queries etc.
The problem is that in the frontend the users see the linked tables, they can even see the design view of each table, but they cannot open it.
I created the ODBC link with both "C:\Windows\system" or "C:\Windows\SysWOW64" but it didn't solve. The ODBC is created at system level.
Furthermore I have changed (allowed) permissions to HKEY_LOCAL_MACHINE/software/ODBC as well as to the HKEY_LOCAL_MACHINE/software/Wow6432node/ODBC
The error message: ODBC-connection to 'XXXX" failed. MS ACCESS can't opend the table in Datasheet view.
Thanks a lot for your help !