Hi All,

I have searched this forum and the web, thinking this must be a quite common problem, but have had no luck.

I have created an ODBC conenction to get Data from a database on a shared drive.

I have the drive mapped, but i want to share this workbook. Not all users would have the drive mapped to the same letter. So i was wondering if i could create the ODBC link to the full location.
e.g. \\SERVERNAME\FOLDER\DATABASENAME
All i can put currently is
F:\FOLDER\DATABASENAME

Any help would be greatly appreciated.

Thanks,

Ian