Group:  Microsoft Access ยป microsoft.public.access.setupconfig
Thread: Linking to Backend

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Linking to Backend
Chaplain Doug 06.07.2006 15:06:02
Access 2003. How may I link to my backend using pathname format of:

\\servername\sharedfolder name
\\hqserver\Human Resources\Databases\HR_be.mdb

rather than having to use

H:\Human Resources\Databases\HR_be.mdb

It seems that the Linked table manager only allows the "H:" form of the path.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
Re: Linking to Backend
"Rick Brandt" <rickbrandt2[ at ]hotmail.com> 06.07.2006 18:16:11
Chaplain Doug wrote:
[Quoted Text]
> Access 2003. How may I link to my backend using pathname format of:
>
> \\servername\sharedfolder name
> \\hqserver\Human Resources\Databases\HR_be.mdb
>
> rather than having to use
>
> H:\Human Resources\Databases\HR_be.mdb
>
> It seems that the Linked table manager only allows the "H:" form of
> the path.

Just navigate to the folder via Network Neighborhood - Entire Network.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Re: Linking to Backend
"Joan Wild" <jwild[ at ]nospamtyenet.com> 06.07.2006 18:49:04
When you use the linked table manager, be sure to put a check in the box at
the bottom ('always prompt for location', or something).

Then use My Network Places to navigate to the backend - that'll use the UNC
pathname.


--
Joan Wild
Microsoft Access MVP

Chaplain Doug wrote:
[Quoted Text]
> Access 2003. How may I link to my backend using pathname format of:
>
> \\servername\sharedfolder name
> \\hqserver\Human Resources\Databases\HR_be.mdb
>
> rather than having to use
>
> H:\Human Resources\Databases\HR_be.mdb
>
> It seems that the Linked table manager only allows the "H:" form of
> the path. --
> Dr. Doug Pruiett
> Good News Jail & Prison Ministry
> www.goodnewsjail.org


RE: Linking to Backend
Chaplain Doug 06.07.2006 19:25:02
Thank you both for the help! God bless.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org


"Chaplain Doug" wrote:

[Quoted Text]
> Access 2003. How may I link to my backend using pathname format of:
>
> \\servername\sharedfolder name
> \\hqserver\Human Resources\Databases\HR_be.mdb
>
> rather than having to use
>
> H:\Human Resources\Databases\HR_be.mdb
>
> It seems that the Linked table manager only allows the "H:" form of the path.
> --
> Dr. Doug Pruiett
> Good News Jail & Prison Ministry
> www.goodnewsjail.org

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net