Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connect MS Access to mysqlDB without ODBC

Status
Not open for further replies.

eizs002

Technical User
Jan 28, 2022
2
0
0
AT
Hi,
due to new group policies we are not allowed to install odbc driver on windows machine.
but we need to connect an access-application to mysql-db.
is there a possible way or a "work around"?
thx.
Br
 
Group policies are administered by your IT department. Your IT department could install the ODBC driver and set up the specific connection so that there is no risk from the standard user getting away with any monkey business with other ODBC connections.

Any workarounds that one would seek would likely be much less appealing to an IT department.
 
Hi spamjim,
you are absolutely right, but its a little bit more complicated.[bigsmile]
We are talking about a global corporation and IT department is easily not willing to do it.
Furthermore, we dont even know who to contact exactly for this purpose...
So unfortunately the only possiblity is to find a solution for our own.
THX.
BR Gernot
 
I would advise your global corporation IT department that because they are not assisting with the very basic setup of an ODBC driver, you are going to do everything you can to circumvent their controls. That will light a fire under them to set you up with the ODBC driver.

Engineering solutions to problems does not always involve hardware and code. People can be engineered as well.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top