INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- Turn Off Ad Banners
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Member Feedback
"...Keep up the good work - excellent site - i'd been looking for something like this for ages !..."
Geography
Where in the world do Tek-Tips members come from?
|
Installation
|
How do I setup Ms Access 97 to access a MySQL server via ODBC?
Posted: 13 Oct 00
|
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. |
Back to MySQL AB: MySQL FAQ Index
Back to MySQL AB: MySQL Forum
My FAQ Archive
 Email This FAQ To A Friend |
|
 |
|
