connection to SQL server

message from Prudhvi Reddy on 17 May 2004
Hi
We are currently using MS ACCESS as front end and backend.We are moving
the back end to SQL server.
In the current code we have the connection property set for the entire
project, and each time we want to connect to the database we say

.ActiveConnection = CurrentProject.Connection

Now I want to connect to a SQL server. I need to change the current
connection of the whole project . Where is this connection property set???
Any help is appreciated

Regards
Reddy
 

Archived message: connection to SQL server (MS Access Error Message)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.