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)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
using network paths rather than drive letters in microsoft query
Hi
This may cause problems otherwise. P.e. your network administrator decides to rearrange folder structure on server, or migrates your database to another server. With network resources mapped locally, you have only remap the source, when you use network paths, you have to redesign your queries. P.S. The best way is to reserve some drive letters for mapping widely used sources, and do mapping via script when user logges on. Then network admin must chenge script only. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "samwardill" <Sam wrote in message ... 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)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
using network paths rather than drive letters in microsoft que
Thanks for the tip. However, I still would like to use network paths rather
than drive letters. If you or anyone else can advise how to do this I would still like to know. "Arvi Laanemets" wrote: Hi This may cause problems otherwise. P.e. your network administrator decides to rearrange folder structure on server, or migrates your database to another server. With network resources mapped locally, you have only remap the source, when you use network paths, you have to redesign your queries. P.S. The best way is to reserve some drive letters for mapping widely used sources, and do mapping via script when user logges on. Then network admin must chenge script only. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "samwardill" <Sam wrote in message ... 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)? |
Reply |
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 |