LittleSmudge
Programmer
I'm not convinced this is the right forum - so if there's a better one please direct me.
I have many MSAccess 2k front ends providing user interfaces to a MySQL datastore via ODBC.
The MySQL db is on one server and users are distributed over 6 sites connected via VPN.
We now have another SERVER that is NOT 'trusted' by the other servers ( It is a client's server ).
However there is a UserName and Password combination that will allow connection between the servers. ( This is totally different to the User Name and Password for MySQL that exists in the ODBC connection string )
Is there any way to set up the ODBC connection so that it will pass the network UserName and Password and get through the restricted tunnel ?
G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.
I have many MSAccess 2k front ends providing user interfaces to a MySQL datastore via ODBC.
The MySQL db is on one server and users are distributed over 6 sites connected via VPN.
We now have another SERVER that is NOT 'trusted' by the other servers ( It is a client's server ).
However there is a UserName and Password combination that will allow connection between the servers. ( This is totally different to the User Name and Password for MySQL that exists in the ODBC connection string )
Is there any way to set up the ODBC connection so that it will pass the network UserName and Password and get through the restricted tunnel ?
G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.