[thelist] MySQL through MS Access?

[Anthony Baratta]

At 09:42 PM 1/13/2002, Peter Kaulback wrote:
>I have a client who has a secure login into their site through ASP, though 
>they have decided to go with Unix and so it will be done in PHP, no 
>problem with this.  However the client works entirely in MS Access.  Is 
>there a way to build and manage a MySQL database through Access, or at the 
>very least mange through Access?  They have to create passwords for 
>employees whenever they are required and don't wish to hire me on for just 
>administering the database.

Option One: Create a PHP Interface to the DB for Admin work.

Option Two: Install the mySQL ODBC driver for Windows and you can user the 
mySQL DB as a "remote" DB with the horrid clunky interface that Access has.

Go with Option one, you'll thank yourself in the long run. The client will 
not be saving themselves time or money going the Access Admin route.
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."