How do you change your ODBC connection?

B

brett

I created a spreadsheet with an ODBC connection to an MS Access db. When I
move the db and spreadsheet to another PC and the path to the db changes the
spreadsheet cannot find the db. I created an ODBC connection on the new PC
and named it the same as the original. What do I need to do to have the
spreadsheet recognize that the db has changed paths?
 
Top