[AccessD] A97 Linked Tables

Hi Mark:

You would use something like i.e.:
Net use \\ServerName\Access97DBShareName. 

No drive letter needs to be created, but of course the appropriate share has
to exist on the host and when you resolved the connection within Access, the
tables would be linked using the same syntax.(File > Get External data >
Link Tables.. > '\\ServerName\Access97DBShareName\MyBE.mdb'.)

HTH
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 12: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&tco
d
>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