Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2005-04-09 : 13:46:30
|
Hi,I have an Access Project Extension (ADE) and I want to create small application that can change the ADE connection without have to press shift-enter and change the ADE connection.My ADE have a startup event that initialize global variables and if the ADE cannot initialize its global variables then it will show the warning and close automatically.I use this command :Dim X as New Access.ApplicationCall X.OpenApplication(my ADE file)It seem that this command open my ADE and because the connection haven't configure correctly then the ADE start it startup command, cannot initialize global variables and close, this make my next syntax : Call X.OpenConnection(.....) fail because the ADE already close.Is there any other way to change the ADE connection without using the syntax above ?I really need that because the ADE no longer have the ability to perform shit-enter function because already disable. The purpose of the application is because I compile the ADP in my computer using (local) as server name, and when I copy the ADE to my client computer the ADE cannot run because the server name should be the DB server name, not using (local) anymore.Any suggestion would be appriciated.Thank'sMike |
|
|
|
|