jakester
04-20-2004, 11:00 PM
I set up a MySQL/PHP driven database. It works fine. But the owner wanted to access the on-line MySQL DB with his MS Access. SO I downloaded a driver from MySQL, 3.51 that allowed us to hook up to the on-line MYSQL. It worked for a while, then it quit cause the ISP folks had to have our IP address and that is changed by Road Runner frequently. But even after I gave them the lastest IP, the driver stilldoes't connect and of course, I checked and rechecked all the ODBC settings on the machines 100X. Does anyone have any ideas on how we can connect a MS Access to an on-line db. I also tried uploading a sample .mdb and set the permissions to 777, but MS Access won't connec tbecause it isn't a trusted source and we couldn't change the security settings because it has to be https protocol to be a trusted source.:D