| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using network paths rather than drive letters in microsoft query
I have set up an Excel sheet that retrieves data from an Access database that
is stored on the local network. Microsoft Query stores the location of this database with reference to a drive letter (i.e. S:\database.mdb). This causes problems if another user tries to use the spreadsheet when the other user has their drive letters mapped differently. Is it possible to store the data source with the full address (i.e. \\server\path\database.mdb)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically save a copy of worksheet from C: to Network Drive | Excel Discussion (Misc queries) | |||
| Web query returns no result from internal network | Excel Discussion (Misc queries) | |||
| Microsoft Query | Excel Discussion (Misc queries) | |||
| Can I download Microsoft Query? Missing software for my Version. | Excel Discussion (Misc queries) | |||
| Microsoft Query Help | Excel Worksheet Functions | |||
Threaded Mode
