You can just install MyODBC on the client (running MS Access) then you can link tables stored anywhere.
have a look at: http://forums.devshed.com/t56700/s.html for more info Hope that helps Nitin ----- Original Message ----- From: "Matthew McNicol" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 09, 2004 7:04 AM Subject: odbc I have a PHP/MySQL database application running on linux hosted webspace (via webfusion.co.uk). I'd like to make the information accessible from a MS Access database which sits on my clients office server (microsoft os), either by using odbc, or an alternative. This is because the client would like to be able to use MS Access for reporting purposes. I don't think odbc is available via the hosted webspace so I may have to export the data periodically to the MS Access database using cron/scheduling. Any recommendations? Matthew McNicol --------------------------------------------- yellowmarker.co.uk [information technology] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]