ODBC - MS Access - MySQL

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 !
lele62Asked:
Who is Participating?
 
PatHartmanCommented:
When I install an app at a large company (too many desktops to personally visit), I ask their IT support to distribute the DSN so that everyone can link to the database.  In situations where I can't get the desktop support people to do this, I create a DSN-less connection.  Here's a link for how to do that.

https://support.microsoft.com/en-us/help/892490/how-to-create-a-dsn-less-connection-to-sql-server-for-linked-tables-in
0
 
Manfred BertlManagerCommented:
Did you try with the MySQL-Client itself? Did you try a JDBC-Connection?
0
 
lele62Author Commented:
C.jpgHi Manfred,
yes I can connect to MySQL server using HeidiSQL 9.5 from any PC.
I have not tried JDBC-Connection, I'd rather not using Java as we get automated Java updates... it doesn't sound a stable solution to me.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
lele62Author Commented:
Hi Pat,
I have never heard of "DSN-less connection". I try to set it up....
0
 
PatHartmanCommented:
The article is for SQL Server but hopefully it will work for MySQL although you may need to futz with the connection string.
0
 
PatHartmanCommented:
two viable solutions
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.