Heenan, Lambert
Lambert.Heenan at AIG.com
Mon Feb 12 12:31:02 CST 2007
Matt, It may be a local security policy imposed on your computer. For example on my machine I can fire up Explorer (Windows, not Internet) and type a UNC path into the address bar and then browse the folders on the network share, but other users with more restricted rights are not allowed to do that - they get an Access Denied message when they try, and can only browse with mapped drive letters. However, access itself is perfectly happy to use tables that are linked via UNC paths, even for users who cannot browse with UNC path in explorer. So the quick solution for you may be to have the browse restriction removed from your machine. Failing that, you may have to do the table linking using code. As I mentioned in an earlier post, I have a table in the front ends of the application I support which lists all the tables that the applications link to. The table has paths to both the production and development versions of the tables. When I want to release a new version of an application, one of the first steps is to relink the tables, and this is all done with code, using the "Linked Tables table" to determine all the paths. In other words, I never use the Access Linked Tables Manager dialog box. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Monday, February 12, 2007 11:48 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] A97 Linked Tables Lambert, Thanks for the suggestion. I can map to this folder thru net use...and according to the Administrator I have full rights...but if I try your suggestion I get the error that I do not have permission to view the folder? Any ideas? Thanks, Mark A. Matte >From: "Heenan, Lambert" <Lambert.Heenan at aig.com> >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, 9 Feb 2007 15:09:50 -0500 > >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=240 > >95 > >&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 _________________________________________________________________ >From predictions to trailers, check out the MSN Entertainment Guide to >the Academy Awards(r) http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline1