Web Hosting, Programming, Marketing & Web Design Solutions By Sunny Oasis

ODBC: How to set up MS Access 97 to access your mySQL database

    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.  See figure below:

      odbc Access: Step 1

    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.  If you haven't already
      done so, see instructions here.  Click the OK button


    5. From the "Link Tables" window (image below), select the table you want to attach and click the OK button.


    6. ODBC could prompt you for the primary key column in tha 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.

Web Hosting - $15.CDN per month, FREE set-up!
For more information, give us a call:
In North America:   1-800-763-3575
Toll Free outside North America:   800-7633-5750
or email: Sales@sunnyoasis.com

 History | Technology | Comparison | Rates | FAQ | Engine Register | Domain Names | Contact | Client Info | Home

Overview Of Our Services
Copyright: 2010 SUNNY OASIS, All rights reserved