[AccessD] A97 Linked Tables

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




More information about the AccessD mailing list