Heenan, Lambert
Lambert.Heenan at AIG.com
Fri Feb 9 16:19:15 CST 2007
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