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

 

[Guest]

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

 

[Simon Harris]

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

Reddy, others may have a different opinion, but in the past, I have used SQL
Server DTS to import the Access data into SQL Server, then used linked
tables connecting to SQL Server. You need to setup an ODBC data source
linked to your SQL server, then in your Access DB, go to tables, right click
a blank space, choose 'link tables' then select 'ODBC' and select your data
source.

Hope that helps.

Simon.