Page 1 of 1

mysql/access/kinda unrelated to php.....

Posted: Mon May 24, 2004 6:53 pm
by dull1554
i have just started getting into VB script and microsoft access, what i wanted to do, and it wont be hard to do once i figure out how to connect, but i want to use access to connect to my MySQL server and i want to pull out all my userinfo and make a report, i just need to get it to connect and i can't get it to,i've tried connecting to localhost and 127.0.0.1 using the default root user with no password but that did not work....andone have any experience or anythoughts?

thanx in advance!

Posted: Tue May 25, 2004 11:15 am
by lostboy
Download the MySQL odbc driver from mySQL (get it here. Install that on your system. Set up and ODBC connection from the control panel, then use the ODBC functions from Access to point to that ODBC link.

Posted: Tue May 25, 2004 2:49 pm
by dull1554
thankyou, works great.....for the longest time i never knew what access was and now i think i love it..it's like database driven VB