title: Changing SQL connection information for DSN-less Access frontend
body: <p>I've got a mission-critical Access 2003 database that changed from a local MDB, to an MDB frontend with the backend on MS SQL Server 2005, using the Microsoft SQL Server Database Migration Assistant (SSMA) software.</p>
  
  <p>Now, I need to permanently change the server that the tables are linked to <strong>from an IP address</strong> (which is changing soon) <strong>to a hostname</strong> pointing to the same server. The server itself is not changing, just the connection string.</p>
  
  <p>It's a DSN-less connection, so the ODBC info is contained within the Access MDB file.  If I try to refresh the table links within Access, it prompts me for a DSN (which I don't want to use).</p>
  
  <p>I've done some Googling, and I've found several scraps of code to have it update itself each time the program launches. But, I'm worried that that could potentially introduce problems or delays for the users.  Is that my best option, or is there some trick to permanently change the connection string stored within the MDB?</p>