*** Edited. Advertising removed (acknowledgement kept) ***

---------------------------------------------------------
10) TIP: CREATE AN ADO CONNECTION STRING THE EASY WAY
---------------------------------------------------------
************************************************** ******
Welcome to Pinnacle Publishing's free bi-weekly
eNewsletter for professional developers.
************************************************** *******
SMART ACCESS eXTRA
Microsoft Access Tips, Trends & Technology eNewsletter
Pinnacle Publishing <A target="_blank" HREF=http://www.pinnaclepublishing.com>http://www.pinnaclepublishing.com</A>
Issue 2.12
June 6, 2001


Many people find the task of creating ADO connection
strings a difficult one. Knowing what provider to use and
what options to specify in the string can be difficult.
Fortunately, there's an easy shortcut:

1) Open Windows Explorer.
2) Create a new text document in a scratch directory.
3) Name the file with a udl extension -- something like
"x.udl." Confirm to Explorer that you really did mean
to change the extension.
4) Double-click the file. That will open the Data Link
Properties dialog box.
5) Now you can choose a provider, pick a database, supply
security information, and so on.
6) Use the Test Connection button on the Connection tab
to make sure it's working.
7) Click OK to save the file.
8) Now open your udl file with Notepad. You'll find that
it has three lines. The first two are always the same;
the third line of the file is a perfect ADO connection
string that you can cut and paste into your VBA code.