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    
post Mar 27 2017, 12:26 PM

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

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
post Apr 11 2017, 03:07 AM

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
@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"

Go to the top of the page
2 Pages V < 1 2

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