Windows Forum

Ask something
Discussion Locked

Laptop: Drive Letter Muddle

0 helpful
3 replies

by will

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Company Database is Access 97 based with data files server database, front end on workstations.
Server running NT4 Server, Clients Win98SE.
Clients access server database through mapped 'E' Drive.
The problem. We want to use laptops for use off site. To use the database, the data files have to be located in the 'E' drive. This is because lots of VB code point to this drive,
ie recordsets, etc. To overcome this I can partition the drive and the database works fine. Problem comes when I want to then use the laptop in the office. I can't map the laptop to the server as an 'E' drive as it exists as a partition.

Anyone know a way I can dynamically re-assign drive letters (hardware profiles would have been easy), or any other way of overcoming the problem?

3 replies

by timthetoolman

Hi,

You could try creating a simple .bat file and put it one the laptops that has the following line...

net use e: \\%computername%\c

(I think thats the right syntax...)

You'd need to share the C drive on each laptop too so that this batfile could map a new "network drive" back to its own c: drive or d: partition (change above refs from c to d) or wherever you put the database but call it e:

You'd name the .bat file something like Setup for Local Use.bat

That should work.

Cheers,
Tim.

This discussion is closed to new replies.