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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
dull1554
Forum Regular
Posts: 680
Joined: Sat Nov 22, 2003 11:26 am
Location: 42:21:35.359N, 76:02:20.688W

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

Post 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!
lostboy
Forum Contributor
Posts: 329
Joined: Mon Dec 30, 2002 8:12 pm
Location: toronto,canada

Post 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.
User avatar
dull1554
Forum Regular
Posts: 680
Joined: Sat Nov 22, 2003 11:26 am
Location: 42:21:35.359N, 76:02:20.688W

Post 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
Post Reply