First:
If you are using Access (97/2000) the strDBType should be set to 'access' not to 'mysql'.
You'll get error-messages using it this way.
As far as I know you can't use an Access database that is on a different server.
You can do this with MS Sql Server (with IP enabled as protocol) or MySql (has IP enabled as protocol by default). In that case you would replace the SERVER_NAME of the database-server with the IP number of the server, i.e. when using MySql on a different server:
strConnString = "driver=MySQL;SERVER=123.123.123.123;PORT=3306;DATABASE=DB_NAME;UID=abcde;PWD=xxxx" '## MySQL
ofcourse replacing the values with the one applicable in your case.
Pierre