mysql interoffice setup

[phpgramma]

I know that I can setup an intranet using MySQL. That's not my question. I prefer to develop in PHP/MySQL, even for internal corporate applications, but my client wants to use MSAccess as their DB shell. Is there a way to integrate Access to an ODBC (with which I have no experience) or something like it, in order to maintain a DB internally- still allowing for this DB to be used on the website? (servers are all in-house)

 

[lgarner]

Yes, use the MySQL ODBC connector and create a DSN for Access to use. As I recall, there are issues with updating tables that don't have a timestamp field, but otherwise it works pretty well.