T
Tim S.
Is there any way to configure the Data Link Properties used
by MS Access Project so that I can enter a Server name
that does not exist on my network but which exists on my
client's network? For example, the server where SQL
Server resides in my development environment is
called: "MyServer", but before my client can run the ADE
file in his environment, he needs to change "MyServer" to
whatever his server is called: eg "DataServer".
Is there a way to create an ADE in my development
environment with "DataServer" as the Data Link Server name.
Secondly, is there any way to run some code in an Access
Project that fires pre-login? What I would like to do is
programmatically connect to a remote server with a VPN
connection, then submit the user name and password. The
only way I could get things to work is by pressing the
Cancel button on the initial login, then the Access
Project loads the start up form by which I programmatically
create a VPN connection and then load the ADE. The login
appears again, I enter the user name and password, and the
application runs. I would like to be able to run the
startup form before the login appears so that I can
establish the VPN connection first, then login.
Thank you in advance for your response,
Tim S.
Print | Copy URL of this post
Expand All Collapse All
by MS Access Project so that I can enter a Server name
that does not exist on my network but which exists on my
client's network? For example, the server where SQL
Server resides in my development environment is
called: "MyServer", but before my client can run the ADE
file in his environment, he needs to change "MyServer" to
whatever his server is called: eg "DataServer".
Is there a way to create an ADE in my development
environment with "DataServer" as the Data Link Server name.
Secondly, is there any way to run some code in an Access
Project that fires pre-login? What I would like to do is
programmatically connect to a remote server with a VPN
connection, then submit the user name and password. The
only way I could get things to work is by pressing the
Cancel button on the initial login, then the Access
Project loads the start up form by which I programmatically
create a VPN connection and then load the ADE. The login
appears again, I enter the user name and password, and the
application runs. I would like to be able to run the
startup form before the login appears so that I can
establish the VPN connection first, then login.
Thank you in advance for your response,
Tim S.
Print | Copy URL of this post
Expand All Collapse All