File reference

[KT]

Hi,

I reference a file on_click on a forms control. Many users use this database.
We are on a network though and some users have the directories mapped to different drive letters which causes an error.

eg. I have the '\\shared-hht' directory mapped to drive S: whilst some have it mapped to drive M:

Is there a way that I can reference the root file without using drive letters?

Many thanks,

KT

 

[Allen Browne]

Use the UNC instead of the drive letters, i.e. enter:
\\shared-htt\somefile

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi,

I reference a file on_click on a forms control. Many users use this database.
We are on a network though and some users have the directories mapped to

different drive letters which causes an error.

 

[Ted Allen]

You can use the UNC path, such as
\\servername\folder\file.ext and just ignore the drive
mappings.

-Ted Allen

-----Original Message-----
Hi,

I reference a file on_click on a forms control. Many users use this database.
We are on a network though and some users have the

directories mapped to different drive letters which
causes an error.

eg. I have the '\\shared-hht' directory mapped to drive

S: whilst some have it mapped to drive M:

 

[dg]

I used the same method, but found it was slower. I delagated/reserved drive
X: for our app to preserve speed.
..d

Hi,

I reference a file on_click on a forms control. Many users use this database.
We are on a network though and some users have the directories mapped to

different drive letters which causes an error.