2012

NOTE If you haven't added any links yet, click the New button, and
follow the procedure for adding database links first.
3 Configure the ODBC Driver:
a In the Edit Link dialog box, select the appropriate ODBC Driver
to define the type of the database to link to, for example Microsoft
Access Driver (*.mdb).
b Click the Setup button. The driver wizard opens, and guides you
through the setup options. If you have difficulties setting up your
connection details, contact your database administrator. When
you finish, the box underneath will show the connection string.
This string can be modified, if necessary.
For example, if you want to select a database with a certain name
(say, test.mdb) that is always next to the model file (as in the
resultant NWD/NWF not the original), type in:
DBQ=%pushpath(%poppath(%currentpath),"test.mdb");
DRIVER={Microsoft Access Driver (*.mdb)};
If you want to select a database with the same name as the original
model file (say, AutoPlant), type in:
DBQ=%join(%removeext(%removepath(%sourcepath)),".mdb");
DRIVER={Microsoft Access Driver (*.mdb)};
Object Properties | 375