Setting Connection Property when opening an access project

[Sacha Vieux-Roy]

I have an access project that I am developing on different computers in which
the SQL Server name and database name differs from computer to computer.
Using a command-line parameter from a shortcut and(or) by using vba code I
would like open a connection to the desired server at startup. The problems
seem to be that the Access Project wants to save the connection settings.
Once connections settings have been assigned they can be changed but not
cleared. When I open an Access Project with incorrect connection settings I
am forced to wait for a futile attempt to connect before I can change to
connection settings.