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.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…