Over the weekend, my company assigned new drive locations (letters) to all of our network shared drives. Now I can't refresh spreadsheets that retrieve data from Access via ODBC. I already went to my list of User DSN's and updated the DSN with the new location but Excel is still looking for the old location. HELP!! I logged alot of hours creating this application and don't want to start over.

Thanks in advance