Is there anything like access for MySQL?
I need something that will allow users to manage DB content for a web site and ideally it would have the ability to support FORM done in something like VBScript? To make the management of tables easier.
Cheers,
Alex
MySQL database administrator
Moderator: General Moderators
-
alex.barylski
- DevNet Evangelist
- Posts: 6267
- Joined: Tue Dec 21, 2004 5:00 pm
- Location: Winnipeg
-
alex.barylski
- DevNet Evangelist
- Posts: 6267
- Joined: Tue Dec 21, 2004 5:00 pm
- Location: Winnipeg
Re: MySQL database administrator
Just dawned on me, there is probably a mysql connection driver which you can use from access to manage a MySQL database from Access, that would be the cats meow.
If you have ever interfaced the two and know of any interesting problems, solutions, articles, resources, please let me know.
If you have ever interfaced the two and know of any interesting problems, solutions, articles, resources, please let me know.
- jayshields
- DevNet Resident
- Posts: 1912
- Joined: Mon Aug 22, 2005 12:11 pm
- Location: Leeds/Manchester, England
Re: MySQL database administrator
phpMyAdmin will probably fit your needs. In regards to a form (I guess you mean like in Access) then there are probably generic solutions for that already somewhere I guess.
-
alex.barylski
- DevNet Evangelist
- Posts: 6267
- Joined: Tue Dec 21, 2004 5:00 pm
- Location: Winnipeg
Re: MySQL database administrator
PMA won't work...the users needs something they are more familiar with unfortunately, especially a Windows like application. Access can apparently connect to MySQL via an ODBC driver, but the last time I tried with OpenOffice, installing the JDBC was such a pain I eventually gave up. Although I did manage to get a MySQL admin tool working, thus the reason I thought I would ask about a MySQL admin tool, maybe something like access.
Re: MySQL database administrator
How about navicat?
Re: MySQL database administrator
I'd go with ODBC if you can, that's what it was designed for. If you can get the normal version of access or some other client that installs properlyPCSpectra wrote:Access can apparently connect to MySQL via an ODBC driver, but the last time I tried with OpenOffice, installing the JDBC was such a pain I eventually gave up. Although I did manage to get a MySQL admin tool working, thus the reason I thought I would ask about a MySQL admin tool, maybe something like access.