hi George,
Use the UNC (Universal Naming Convention) address
rather than the mapped or mounted drive. When
you use the Linked Table Manager (Tools->
Database Utilities), select the path to your
BackEnd via My Network Places so that you end up with an something like
\\YourServerMachineName\c-drive\MyDataFolder\MyBackEnd.mdb
That is the cross-platform method of addressing
files on a network. Once set, the back end will
be found from any machine on your network that
you place the front end. It's worth noting that
the closer your BackEnd file is to the root of
your drive, the faster the access will
be. ...\Documents and Settings\... is NOT the place for a data file
Brett
At 04:39 11/06/06, you wrote:
>Greetings All,
>
>Not my first problem by any means but first question here...so please
>be patient with me.....
>
>I have designed and developed a clunky database for my little
>specialty pârts business; amazingly (to me anyway) it seems to do
>almost all the things I want. I have now got to the stage where I
>would like to split it and copy the front end on another couple of PCs
>using mine as a server where the back end will live,but.....
>
>...On my PC I have split it and it works fine but if I try to copy the
>FE to another PC the path is wrong. How do I change the path? I can't
>see any obvious way of doing this ....
>
>All help/advice/counsel is very much appreciated,
>
>
>Best Regards,
>
>George
>
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>--
>Internal Virus Database is out-of-date.
>Checked by AVG Anti-Virus.
>Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 02/06/06
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 02/06/06
------------------------ Yahoo! Groups Sponsor --------------------~-->
Everything you need is one click away. Make Yahoo! your home page now.
http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/