Excel: Linking data 1

[EllieFant]

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

 

[MattSmithProg]

Hi,

You can use the Universal Naming Convention UNC.

Ie. \\ServerName\Folder\File.mdb

HTH Matt Smith

No two nulls are the same

 

[EllieFant]

Where do I do that at? I can't find anyplace to change the path.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net

 

[MattSmithProg]

You will have to recreate the query but when you create the new query instead of selecting a drive to access the database type the UNC as above instead. Matt Smith

No two nulls are the same