Msaccess/Mysql experts only MSACCESS 2016-2019

The project is very simple , I have a ms access program as a front to mysql that connects to a remote mysql server thru odbc connect 8.0 via linked tables Currently it works flawlessly on a desktop. All i need is an interface and code to bypass the odbc login screen thru VBA and connect to the remote mysql. Basically i want to manage all functionality from within msacces such as user, pass, database, ip address and so on, all of this should be entered and saved for future use and be able to relink to the back tables in mysql without doing it everytime i open the program . The users/pwd should be taken directly from the remote [login to view URL] you are familiar with workbench then i need something similar to connect to it Please don't shoot from the hip, if you do not know this do not bid. An expert in msaccess should take no more than a day to write Note that the msaccess versions are 2016 and 2019 ODBCDirect workspaces are not supported in Microsoft Access 2016 Setting the type argument to dbUseODBC will result in a run-time error. Use ADO if you want to access external data sources without using the Microsoft Access database engine.