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: 18,999
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.

Boyd Trimmell aka Hi Tech Coach ( HiTechCoach.com free Access stuff)
Microsoft MVP 2010-2015 - Access Expert
Inventory Control, Accounting, BPM, and CRM Software Developer
"If technology doesn't work for people, then it doesn't work."
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"


-- Share & Enjoy! --
Go to the top of the page
2 Pages V < 1 2

Custom Search
RSSSearch   Top   Lo-Fi    21st July 2018 - 08:43 AM