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.

 All Forums
 Other Forums
 MS Access
 Change Access Connection

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.Application
Call 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's

Mike

   

- Advertisement -