ACCESS FEED: Re: [MS_AccessPros] Network path

Selasa, 14 Mei 2013

Re: [MS_AccessPros] Network path

John and Duane,
Thanks. I was able to change the path to \\path and now it is independent of drive letter.

Kind Regards,
Kumar

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Kumar-
>
> In the Linked Table Manager, select Always Prompt for New Location, then
> when you click OK see the Open dialog, navigate to the Network icon in the
> left panel and search for the share. That will get you a \\ path.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
> Sent: Monday, May 13, 2013 12:51 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Network path
>
> Duane,
> Sorry for responding late. I am linking the tables of the backend using
> Linked manager. It automatically takes the path as Y:\. I am unable to find
> out a way to change the path of the tables to \\..... as suggested by you.
>
> Kind Regards,
> Kumar Iyer
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom
> <duanehookom@> wrote:
> >
> > Kumar,
> >
> > Map the back end using the network path such as:
> > \\MySharedServer\ShareName\Apps\DB\MyAppBE.accdb
> >
> > Duane Hookom MVP
> > MS Access
> >
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: access_kri@
> > > Date: Sat, 11 May 2013 18:32:29 +0000
> > > Subject: [MS_AccessPros] Network path
> > >
> > > Dear All,
> > > After developing my database, I moved a copy of front and back end to
> our company network drive and relinked my tables using Link manager. I had
> mapped it as Y drive in my laptop. My other colleagues mapped it as
> different drives in their PC. Those who had not mapped the shared folder as
> Y drive, could not access the database. I asked them to map the share folder
> as Y drive. My question is when I link the tables, why the physical path of
> the table is stored and how I can I make it independent of the physical
> path?
> > >
> > > Thanks and Regards,
> > > Kumar
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>