I have MS Access 2000 on my WinXP Pro machine.

I have a PivotTable in my database "OrderCountV4" which pulls it's data from another database called "Count Comparison". "Count Comparison" is on our network and "OrderCountV4" connects to it by System DSN.

When I open "OrderCountV4" on a Win98 machine, open the PivotTable and refresh it works fine. But when I do the same thing on my WinXP machine by clicking the Refresh icon, I get a Disk or Network Error.

Any idea on how to correct this problem?