Setting the connection on startup

[mistux]

I am developing an ADP and when I move it from my office to th
customers I have to manually reconnect to thier server, changing fro
the settings that pointed to my server. (Also, it takes about
minutes before Access lets me have control back so that I can chang
it, I guess it is trying to establish the connection over and over.)

Is there any established code that I can put into a startup ruteen tha
would prompt for the connection info (like server name and possible
user) then re-establish the connection

 

[aaron.kempf]

check out the sample northwind.adp it has some good examples similiar
to that

-aaron

 

[mistux]

I thought that I did look at that, and did not find anyting like that.

However, I will look again

 

[Sylvain Lafontaine]

Check the post from Adam Bunter at:
http://groups.google.ca/group/micro...ection+openconnection&rnum=1#2e56a842bf4c6bf0

This will tell you how to disconnect ADP so that next time there will be not
connection prompt (don't forget to close any object that will still be
opened). You can also search this newsgroup for « CloseConnection
OpenConnection » for more information:

http://groups.google.ca/group/micro...econnection+openconnection&start=0&scoring=d&

(Hint: sort by date).

 

[mistux]

Thanks I will give them a look

 

[Simon Shaw]

I have a similar issue, and this thread has been very helpful, but the
sticking point is:

How do I present a list of available SQL Servers?

At present I am just giving them an inputbox, but this is not really
satisfactory!

TIA
Simon

 

[mistux]

How do I present a list of available SQL Servers?

I haven't found anyway to do that yet, either

 

[Graham R Seach]

Simon (and mistux),

Take a look at the two chunks of code at
http://www.pacificdb.com.au/MVP/sqlserver.htm.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia