Problem with ODBC from MS Access 2007 to MS Sql Server 2008

Hi experts, I need some help with ODBC Connection Settings from MS Access 2007 to Sql Server 2008.

Here is the Scenario, I have created a Database(StagingDB) with 5 tables on SQlServer 2008 and I have
Developed an MS Access 2007 Front End using Linked tables and ODBC to Insert/ Update data into these 5 tables.
This is just working fine in my Dev database. ODBC Connection Settings are pointing to my DevServer.

All I wanted to do now is, I want to point the ODBC Settings to the same database on my Test Server and
then to Production Server.

I have Changed the Server name in the ODBC File to point it to my Test Server and If I try to Insert
some data into test server its stil going into the database on Dev server.

Is this the right way to do. Please help me with this.

thanks In Advance..
KuldeepReddyAsked:
Who is Participating?
 
David Christal CISSPConnect With a Mentor Commented:
You may just need to restart Access after changing the files.  Otherwise, use DSNs instead of file based connections.  Then, when you want to switch from test to production, just change the DSNs and restart Access.
0
 
khairilCommented:
Hi,

Try create back all the link table inside Access file to new production server.

Good luck.
0
 
KuldeepReddyAuthor Commented:
Hi Khairil, Thanks for your response. If i create all the Link tables again then Do I need to Re Create the Forms that are using these link tables?
0
 
jbyers79Commented:
try updating the linked tables from Linked Table Manager
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.