ADP hard code connection string?

[Guest]

I've seen people suggest how to hard code a connection string into an ADP/ADE
file, but nobody has mentioned where to actually type it in.
I'm making ADE files for clients now. I use Runtime for some of them.
Runtime won't show the connection box, so I have to hard code the connection
string in before packaging it.
FYI, I have created a new menu bar with the connection button on it, but it
does nothing unless the application actually opens, and I'm having difficulty
connecting, therefore it won't open.

To make it work, I'm currently having to rename my server, reboot, connect
via Access ADP, close/reopen Access, log on, then I can package the file as
an ADE for a specific client.
Next client, I redo it all over again.

Obviously there is a better way.

I don't open a connection every time I need one, I just use the connection
that opens when Access opens. Where do I hard code the connection info so
Access finds the server by itself? What window do I open to set the string?
How do I stop access from having to connect to check the connection - so I
don't have to rename my server each time?

Thanks in advance for help,
Steve White

 

[Sylvain Lafontaine]

This is limitation a ADP and this is also why it's better to hard code an
empty connection string ( "" ) if you want to package your ADE for another
server.

However, in your case, using the SQL-Server Network Client Utility for
creating aliases might be a better idea than renaming your server each time
(but I didn't test this idea for ADE because I don't use them).