UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Advice On Using Runtime I Access 2010, Access 2010    
 
   
HiTechCoach
post Mar 27 2017, 12:26 PM
Post#21


UtterAccess VIP
Posts: 19,008
Joined: 29-September 03
From: Oklahoma City, Oklahoma


QUOTE
Yes I have 4 additional drives on my PC so I was planning to rename a spare one to the same drive letter that is on the network


No need to go through all that. I find ti best to to avoid renaming a drive so it does not "break" anything else on the PC.

You can simply create a share for a folder on your PC. Create a Mapped a drive letter to the new share. Another advantage to this method is that it is easy to change to a different mapped drive letter is you need to in the future.
Go to the top of the page
 
Guus2005
post Apr 11 2017, 03:07 AM
Post#22



Posts: 7
Joined: 21-November 08
From: The Netherlands


You can use the SUBST command to map a directory to a letter.
Like this:

SUBST P: "D:\DTS\Application\HRM\IAP"

All files on D:\DTS\Application\HRM\IAP can be accessed through the P: drive letter.

All tables in the frontend are linked to the P:\IAPDATA\Backend.accdb wherever P: is.
IAPDATA is a subdirectory on D:\DTS\Application\HRM\IAP.

I've read that this way it is faster also.

I have created a batch file to create the driveletter
CODE
@echo off
echo Create mapping

rem Remove if P: exists
if exist P:\ subst P: /D

rem Create the new mapping
if not exist P:\IAPDATA subst P: "D:\DTS\Application\HRM\IAP"


HTH:D
Go to the top of the page
 
2 Pages V < 1 2


Custom Search
RSSSearch   Top   Lo-Fi    19th October 2018 - 06:10 AM