Accounting
Configuration
Handbook
 | |
| Configure ODBC32 in the Control Panel |
- Open the Control Panel and double click on the 32bit ODBC icon. (image)
- Select the File DSN tab. (image)
- Click on the Add button to add the new driver. (image)
- Select the MySQL driver which you have installed and click on Next.
- Name the file MaineStreet.DSN.
- Click on the Next button and then on the Finish Button.
- Back in the ODBC Data Source Administrator window select the MaineStreet.DSN
file and click on the configure button.
- In the TDX mysql ODBC Setup window enter the Database Name you will be linking to. (image)
- Enter the name of the server on which your database resides
- Enter your username and password, then click on OK.
MS Access instructions to link to an ODBC database.
- To link data from an external source, open your database and select
File/Get External Data/Link Tables from the menu bar. (image)
- In the Link dialog box change your Files of Type selection to ODBC Databases. (image)
- In the Select Data Source Window double click on the MaineStreet.DSN file. (image)
- In the TDX mysql Driver Connect window enter the name of your database, the server, your userid and password and click on OK. (image)
- Once the connection has been made Access will display another Link Tables box. Select the tables to which you would like to link and click on OK. (image)
- As each table is being processed Access will require you to select a field which has a unique value to be used as an index. Do this for each table. (image)
- The linked tables will be displayed with a "globe" icon and can be manipulated, queried, modified same as any other attached table from an external source. (image)
| | |
