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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Manfred BertlManagerCommented:
Did you try with the MySQL-Client itself? Did you try a JDBC-Connection?
0
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.