[AccessD] A97 Linked Tables

Never heard of any problem with using UNC paths. You may be confusing that
with using long filenames in paths.

If you are linking to a file in "\\server\share\Some Long Path Name\And a
SubFolder" then you can get a performance hit as the OS has to walk the
folder path resolving long file names to 8.2 file names.

To eliminate that problem you can use the short file names in the linked
file path, like

\\server\share\SomeLon~1\AndASu~1

See http://support.microsoft.com/kb/891176/en-us

Lambert


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Friday, February 09, 2007 4:29 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] A97 Linked Tables


I could swear though that unc mapping was slower than physical mapping. That
may have been fixed long ago however.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Friday, February 09, 2007 3:10 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] A97 Linked Tables

No "mapping" is required.

In Access when you browse to where the back end is to link to its tables,
instead of selecting the drive letter and browsing to the folder with the
MDB file, type 
	\\SERVERNAME\SharedFolderName
in the file name box of the file select dialog box. Hit enter and then you
will see the folders on the share and you can browse to the backend. The
paths stored within the front end will then be UNC paths instead of mapped
drive letter paths.

HTH

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Friday, February 09, 2007 3:00 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A97 Linked Tables


Thanks Jim,

I was using Net Use to link to the other machine...I'm on NT (SP4 I
think)...How would I map in this format?

Thanks,

Mark



>From: Jim Lawrence <accessd at shaw.ca>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] A97 Linked Tables
>Date: Fri, 09 Feb 2007 11:14:38 -0800
>
>Hi Mark:
>
>You can map the BE in the format i.e: \\server1\Access97DB then you
>will not have to use drive letter mapping.
>
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Friday, February 09, 2007 11:01 AM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] A97 Linked Tables
>
>Hello All,
>
>In A97 I need to link the FE to the BE in a shared folder on the
>network.
>I
>
>have the folder mapped as a drive on my machine...the users will not.
>
>Do I need to map the drive on each of their machines...or...
>
>IS there another method of linking these tables?
>
>Thanks,
>
>Mark A. Matte
>
>_________________________________________________________________
>Valentines Day -- Shop for gifts that spell L-O-V-E at MSN Shopping 
>http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095
>&tcod
>e=wlmtagline
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
FREE online classifieds from Windows Live Expo - buy and sell with people
you know
http://clk.atdmt.com/MSN/go/msnnkwex0010000001msn/direct/01/?href=http://exp
o.live.com?s_cid=Hotmail_tagline_12/06

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com