connection to SQL server

[Prudhvi Reddy]

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

 

[Support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting