Re: PHP/MySQL to M$ Access

Access has to be running on a Winders machine. At least the drivers. Another option might be to migrate the data, and use ODBC and linked tables to let Access still work temporarily, but really have the data already transitioned. Otherwise it is a weird linked ODBC bouncing off a Windows machine on the way to the data. Chris Andrew wrote:

Hi, Until we completely migrate an application from M$ Access to PHP/MySQL, I need to figure out a way to temporarily query an Access DB from PHP/MySQL. I am aware of this article on PHP Builder: http://www.phpbuilder.com/columns/timuckun20001207.php3?page=1 which discusses using ODBC Socket Servers, but the article assumes the M$ Access db is on a winblows machine. In my case, the Access DB is on a Linux machine (served thru' Samba - isn't Linux great... :-) Anyways - could someone offer me some advice - all I need is some some simple SELECT queries on the Access tables. Many Thanks, Chris Email: candrew@oxspring.com Web: www.oxspring.com