[AccessD] A97 Linked Tables

Heenan, Lambert Lambert.Heenan at AIG.com
Fri Feb 9 14:09:50 CST 2007


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




More information about the AccessD mailing list