Hi there, i would like some help, i wanna be able to access my MySQL database using MS Access XP/2003 and i am new to this sql stuff so some help would be greatly apreciated.<br /><br />Steven<!--content-->
Hi Steven.<br /><br />I'm affraid that, at least as far as I know, that is not possible. You have to use a MySQL client program to access your database.<br /><br />To work on the data using MS Access you'd have to export it to a format that MS Access understands (CSV is a good option and phpMyAdmin provides a way to do that) and then import it again.<!--content-->
I wouldn't have thought so either but, try this<br /><a href="http://www.washington.edu/computing/web/publishing/mysql-access.html" target="_blank">http://www.washington.edu/computing/web/pu...sql-access.html</a><!--content-->
Well, we're always learning! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><br /><br />Steven, try the directions on the page CrazeeGeek pointed. They seem pretty straightforward and easy to accomplish.<br /><br />Thanks for the tip, CrazeeGeek! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="" border="0" alt="wink.gif" /><!--content-->
No prob, I just want know if it works okay.<!--content-->
Great find CrazeeGeek!<br /><br />Please do let us know if it works Steven!<!--content-->
Hi Steven.<br /><br />I'm affraid that, at least as far as I know, that is not possible. You have to use a MySQL client program to access your database.<br /><br />To work on the data using MS Access you'd have to export it to a format that MS Access understands (CSV is a good option and phpMyAdmin provides a way to do that) and then import it again.<!--content-->
I wouldn't have thought so either but, try this<br /><a href="http://www.washington.edu/computing/web/publishing/mysql-access.html" target="_blank">http://www.washington.edu/computing/web/pu...sql-access.html</a><!--content-->
Well, we're always learning! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><br /><br />Steven, try the directions on the page CrazeeGeek pointed. They seem pretty straightforward and easy to accomplish.<br /><br />Thanks for the tip, CrazeeGeek! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="" border="0" alt="wink.gif" /><!--content-->No prob, I just want know if it works okay.<!--content-->
Great find CrazeeGeek!<br /><br />Please do let us know if it works Steven!<!--content-->