Identifying individual users who all use a shared access database.

>I have two users, Andrew and Nancy, who each have their own computer
and can connect to a common database called "employees.mdb" which
resides on a network server. On that same network server, there is a
folder containing jpegs of the employee pictures. When either person
brings up an employee's file, the computer goes into the network and
downloads the picture and displays it on the screen as part of the
form. Works fine, EXCEPT:
>
Andrew ----------------------
Server:Employees.mdb
Nancy-------------------------
>
Also on server the folder with jpegs: \pictures
>
The problem is, Andrew's computer sees the path to the picture folder
as J:\EmployeeData\pictures\, while Nancy's computer sees it as
G:\EmployeeData\pictures\
Whenever a picture is requested, I use VBA code to construct
the path to the picture, such as
J:\EmployeeData\Pictures\Frankenstein.jpg
So, that's fine for Andrew, but Nancy sees nothing, because her
computer does recognize the path to "J". If the module on the server,
namely Emploiyees.mdb, knew who was making the request, it could put
"J" or "K" in the path name. Of course, the module could prompt the
user each time the form looks for a different employee to say, in
effect, "Who are you?", but that is unacceptable.
Also unworkable is to ask the user when first logging on "who
are you" and put the answer into a global variable. This doesn't work
because Andrew and Nancy are often logged on at the same time, and
when the 2nd user logged in, it would clobber the first user's path to
the pictures.
My New Year's question for the group is: Can I determine,
within the server dabatase VBA module, which user is making the
request at the time the request is made?
Thanks and Happy New Year. Pete Brady

I have two users, Andrew and Nancy, who each have their own computer
and can connect to a common database called "employees.mdb" which
resides on a network server. On that same network server, there is a
folder containing jpegs of the employee pictures. When either person
brings up an employee's file, the computer goes into the network and
downloads the picture and displays it on the screen as part of the
form. Works fine, EXCEPT:
>
Andrew ----------------------
Server:Employees.mdb
Nancy-------------------------
>
Also on server the folder with jpegs: \pictures
>
The problem is, Andrew's computer sees the path to the picture folder
as J:\EmployeeData\pictures\, while Nancy's computer sees it as
G:\EmployeeData\pictures\
Whenever a picture is requested, I use VBA code to construct
the path to the picture, such as
J:\EmployeeData\Pictures\Frankenstein.jpg
So, that's fine for Andrew, but Nancy sees nothing, because her
computer does recognize the path to "J". If the module on the server,
namely Emploiyees.mdb, knew who was making the request, it could put
"J" or "K" in the path name. Of course, the module could prompt the
user each time the form looks for a different employee to say, in
effect, "Who are you?", but that is unacceptable.
Also unworkable is to ask the user when first logging on "who
are you" and put the answer into a global variable. This doesn't work
because Andrew and Nancy are often logged on at the same time, and
when the 2nd user logged in, it would clobber the first user's path to
the pictures.
My New Year's question for the group is: Can I determine,
within the server dabatase VBA module, which user is making the
request at the time the request is made?
Thanks and Happy New Year. Pete Brady

>You are coming at this from the wrong direction. What you should do is to
>specify the full network path of the folder instead of a mapped drive. The
>full path will begin \\<server name>\<share name>, and will be the same from
>any computer on the network.