Access .adp using UDL's

[Livvie]

I need to use a UDL for creating the connection to a packaged access
application. (using developer extensions packaging wizard). This works
fine everywhere that expicit code is used behind the forms etc but when
the application is packaged the current connection is saved and when the
app opens up that is the connection that is used. I need to open the
application using whatever connection is specified in the UDL. Maybe there
is a way to do this using the registry- Does anyone know how to do it.

 

[Sylvain Lafontaine]

Never tried it but here a possibility. First, set the connection string to
the null string before packaging:

Application.CurrentProject.Connection = vbNullString.

Second, when the project opens, it should locate of UDL file and use the
Application.CurrentProject.OpenConnection call to use it as its new
connection string. You will find an exemple of opening a new connection and
locating the UDL file in the following references:

http://www.databasejournal.com/features/mssql/article.php/3367271

http://groups.google.com/group/micr...pplication+Name&rnum=3&hl=en#7ab3044961432f09