Modify the Connection String 1

[LeanneGodney]

Hey,

Does anyone know how to view/modify the connection string connecting a project to a sql server database? When I first set it up the wizard asked me a few questions and connected up, but I'd like to perhaps change servers, or modify the connection a bit.

Any help would be appreciated!

Thanks,
Leanne

 

[cmmrfrds]

I usually create a function to run tests and then create a Macro to run the function. Then do a Control G to look at the immediate window.

Macro.
runcode
test1()


Public Function test1()
Debug.Print "connection = "; CurrentProject.Connection
End Function

 

[cmmrfrds]

As far a changing the connection go to File on the Menubar and select Connection. You may need to click the pull down arrows when you open the window if the Connection doesn't show up. You can change the connection if you want or you can change the connection through code.

 

[LeanneGodney]

Thank you!! The File --> Connection is exactly what I was after.