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!

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." wrote:

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!

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).


"Ron Coderre" wrote:

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." wrote:

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!