The spreadsheet that I am working on uses drive letters to access files. I'm trying to convert them to UNC paths. I have to open external Excel spreadsheets, and an Access database. The spreadsheets are opening fine with UNC paths, however I can't get the Access database to open.
I get an error message stating that the database is missing, open exclusively by another user, or not an ADP file. I can access it using the drive letter in the path.
Thank you in advance for any help.