World Wide Web Hosts Net mysql

World Wide Web Hosts Net provides the best hosting support in the business. If the information you need is not covered in one of the areas addressed in this Manual, send our Support Team a detailed email from the Support Form and we guarantee a response within 24 hours.

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

Open MS Access and create a new database.
From the file menu, choose File and then Get External Data and then Link Tables. See figure below:
From "Link" window that comes up, choose ODBC Databases()
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.
From the "Link Tables" window (image below), select the table you want to attach and click the OK button.
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:
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.

Hosting, web hosting, web site hosting, website hosting, internet hosting, world wide web hosting, quality hosting, cheap hosting, e commerce, e-commerce, web design, webpage design, web page design, fast, reliable, no set-up fees, fiber optic, fiberoptic, backbone, award winning.

Back 1 page

Top of page

* All prices \$NZ unless otherwise specified Currency converter