Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I setup Ms Access 97 to access a MySQL server via ODBC?

Installation

How do I setup Ms Access 97 to access a MySQL server via ODBC?

by  devnull22  Posted    (Edited  )
1. Open MS Access and create a new database.
2. From the file menu, choose File and then Get External Data and then Link Tables.
3.From "Link" window that comes up, choose ODBC Databases.
4. From the "Select Data Source" Window, choose the DSN name you've setup for your online mySQL database.
5. From the "Link Tables" window, select the table you want to attach and click the OK button.
6. ODBC could prompt you for the primary key column in that table, if it can't find it. Specify one and that's it! The online mySQL table is now attached to your local access database:
7. You may open the table, update, inset or delete records. To attach all database tables, follow the above steps for each table in your database.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top