[an error occurred while processing this directive]
[an error occurred while processing this directive]
[an error occurred while processing this directive]
[an error occurred while processing this directive]
[an error occurred while processing this directive]
[an error occurred while processing this directive]
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.
[an error occurred while processing this directive]