Hi,
I have an access Adp that I would like to change the SQL-server-connection for from another Access database (mdb, accdb or adp). i can use the sample:
Application.CurrentProject.OpenConnection strConnect
to change the connection from within the access project itself. but how do i do this externally. I don't want to use CurrentProject. Rather i would like to use an application located on C:\myDb\Abc.Adp for example and change the connection for that project.
you can preview the code for doing the current project on microsoft KB:
http://support.microsoft.com/kb/306881
thank you
I have an access Adp that I would like to change the SQL-server-connection for from another Access database (mdb, accdb or adp). i can use the sample:
Application.CurrentProject.OpenConnection strConnect
to change the connection from within the access project itself. but how do i do this externally. I don't want to use CurrentProject. Rather i would like to use an application located on C:\myDb\Abc.Adp for example and change the connection for that project.
you can preview the code for doing the current project on microsoft KB:
http://support.microsoft.com/kb/306881
thank you