MySql to Access...Need help

[md_doc]

I have a database question.

I have a membership website online. I would like to be able to access the mysql database through Access. Is this a good idea? I am tired of using phpmyadmin to search and find user information. It is just a pain. The problem is, I have no idea how to set this up in Access. Or how to find the information needed to set this up.

Any thoughts or help will be great!

Thanks!

[ryanhellyer]

I'm not sure if this is possible, although I'm not 100% certain. There are a variety of different tools available for modifying databases though, so perhaps do some googling to find an alternative to phpMyAdmin.

[BigAlReturns]

Are you on a dedicated server? If so, then talk to your host and they should be able to install some desktop based database modification server (assuming it runs on Linux then it will be free for the software, if not the installation). You could then login to this remotely and edit info that way, which would be a nicer solution.
As to "Access" access, I've never heard of anyone doing this. I haven't used Access for a long time, but as I remember it, its quite differently set up to a typical MySQL database structure, so there might be some problems here.
The other option would be to write (/have written) a web based front end specifically for your application. This would be time consuming to edit masses of different fields, in lots of different tables, but for small changes could well be the most effective solution. For example, if you just wanted to change a users "subscription" from "NO" to "YES", then you could write a web based front end to this in a matter of minutes, which would save clicking through tons of phpMyAdmin pages to get to what you want.