I have an access project that has the connection set.  I would like to
be able to control the applications db connection through a UDL.

I was wondering what the best approach to this might be.  Also would
there are any impacts to the existing application code to consider
other than the application has to know where to locate the UDL file.

Thanks.

__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

Create the .UDL then in your Access code change the connectstring to:

Connection.ConnectString = "File Name=Drive\Path\UDLFilename.udl"

In the string itself it is important to not have a space on either side of
the =.


|-----Original Message-----
|From: Tad Groves [mailto:tegrovesjr@r...]
|Sent: Monday, April 22, 2002 6:29 AM
|To: Access
|Subject: [access] Universal Data Link
|
|
|I have an access project that has the connection set.  I would like to
|be able to control the applications db connection through a UDL.
|
|I was wondering what the best approach to this might be.  Also would
|there are any impacts to the existing application code to consider
|other than the application has to know where to locate the UDL file.
|
|Thanks.
|
|__________________________________________________
|Do You Yahoo!?
|Yahoo! Games - play chess, backgammon, pool and more
|http://games.yahoo.com/
|
|