Problem with ODBC from MS Access 2007 to MS Sql Server 2008
Posted on 2010-09-08
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..