Pivot Table - ODBC Link to Access db

[Kirk P.]

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!

 

[Ron Coderre]

If you know the UNC path to the MS Access file,
you could use the PivotPlay add-in at Debra Dalgleish's website to point the
Pivot Table to the new location:

http://www.contextures.com/xlPivotPlay01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Kirk P.]

Downloading anything here is a no-no. Corporate has locked us out for any
downloads without prior approvals.

I see your add-in allows you to manipulate the Connection Info. This is
exactly what I want to do. I thought the Connection Info was stored in a DSN
file somewhere, and all you had to do was open the DSN file using Notepad and
change the connect string to whatever you wanted. For PivotTables, I can't
find the DSN file (if one even exists).