MartyConnelly
martyconnelly at shaw.ca
Fri Feb 9 16:36:33 CST 2007
Try to keep the mdb file up close to the root to avoid a`lot of OS directory permissions checks Here are some mapping/UNC connection functions from Randy Birch that will help Look through related functions too: WNetGetConnection: Get UNC Path for Mapped Drive http://vbnet.mvps.org/index.html?code/network/uncfrommappeddrive.htm WNetConnectionDialog: Invoking the Map/Disconnect Drive Dialog http://vbnet.mvps.org/index.html?code/network/wnetconnectiondialog.htm JWColby wrote: >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 > > > -- Marty Connelly Victoria, B.C. Canada