I've got a pivot table on the network that reads a table in an Access
database. I'm mapped to the R drive, my partner is mapped to the F drive.
When my partner tries to refresh the pivot table, he gets an ODBC Microsoft
Access Driver Login Failed error, telling him R:\blah blah is not a valid
path.

So how do I go about changing the letter drive mapping to the UNC? I would
think there is a DSN file somewhere that has connection instructions that I
could manipulate, but darned if I can find anything. I HAVE modified the SQL
in Microsoft Query to use the UNC, but that's not solving the problem.

Help!