I have an Excel worksheet that I have linked to an Access Query. Both the worksheet and the database reside on a network drive. The drive it is on is networked as the "F" drive on my computer, but the "G" drive on my bosses computer. Because our drives share a different letter, the worksheet will not update.
How can I alter the path from the worksheet to the database so that the drive letter doesn't matter.
Any help would be appreciated.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**
lena.wood@starband.net
How can I alter the path from the worksheet to the database so that the drive letter doesn't matter.
Any help would be appreciated.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**
lena.wood@starband.net