KuldeepReddy
asked on
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..
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..
ASKER
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?
try updating the linked tables from Linked Table Manager
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try create back all the link table inside Access file to new production server.
Good luck.