[AccessD] Connecting to network drive

Are the users allowed to change the connection?  In other words, do you
set the connection in code?  If so, just use the UNC path as the path
instead of the mapped path.  Mapping has been a last resort since Access
gained support for UNC.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Thursday, November 20, 2008 8:29 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Connecting to network drive

I need to link to tables in another access database but the linked table
wizard wants to use a drive letter. The problem is that different users
have the same drive designated with different letters. I found the
following information but am unsure how to implement it. I thought I
could change it in the msysobjects table but no go.


Mapped drive connections would be something like:

H:\apps\MyApplications\MyAccess.mdb



And UNC would be something like:

\\MySecondServer\apps\MyApplications\MyAccess.mdb



Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com