software

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)?

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.laanemetslt;atgt;tarkon.ee )quot;samwardillquot; lt;Sam gt; wrote in message
...
gt;I have set up an Excel sheet that retrieves data from an Access database
gt;that
gt; is stored on the local network. Microsoft Query stores the location of
gt; this
gt; database with reference to a drive letter (i.e. S:\database.mdb). This
gt; causes
gt; problems if another user tries to use the spreadsheet when the other user
gt; has
gt; their drive letters mapped differently. Is it possible to store the data
gt; source with the full address (i.e. \\server\path\database.mdb)?
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.

quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; This may cause problems otherwise. P.e. your network administrator decides
gt; to rearrange folder structure on server, or migrates your database to
gt; another server. With network resources mapped locally, you have only remap
gt; the source, when you use network paths, you have to redesign your queries.
gt;
gt; P.S. The best way is to reserve some drive letters for mapping widely used
gt; sources, and do mapping via script when user logges on. Then network admin
gt; must chenge script only.
gt;
gt;
gt; --
gt; Arvi Laanemets
gt; ( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
gt;
gt;
gt; quot;samwardillquot; lt;Sam gt; wrote in message
gt; ...
gt; gt;I have set up an Excel sheet that retrieves data from an Access database
gt; gt;that
gt; gt; is stored on the local network. Microsoft Query stores the location of
gt; gt; this
gt; gt; database with reference to a drive letter (i.e. S:\database.mdb). This
gt; gt; causes
gt; gt; problems if another user tries to use the spreadsheet when the other user
gt; gt; has
gt; gt; their drive letters mapped differently. Is it possible to store the data
gt; gt; source with the full address (i.e. \\server\path\database.mdb)?
gt;
gt;
gt;