Geek asks and answers

Change connection to SQL Server in Microsoft Access 2003 ade file

I developed an Access 2003 application connected to SQL Server.

My problem is that I developed the software on my server, and the application runs on the client network on a different (identical) server.

As a result, my executable file (Aka.ADE) does not open on the client computer due to a poor SQL Server connection.

My solution so far has been to open the application file (.ADP) on the client computer, changing the communication path from there, and then creating an executable file there. My client now has only the Access runtime, so I cannot do this.

I wonder if there is a way to define a connection in an ADE file this way. (I know that I can change it through VBA, but when the connection is initially false, I don’t even get to the VBA code stage.)

+3
source share
1 answer

, , , . , sql 2008 "SQL1", SQL Express Express "SQL1", . , . .

, - . ADE , . , , . , , .

+1

More articles:


All Articles