Identifying individual users who all use a shared access database.

[Paul 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:Employee s.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\Frank enstein.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

[Baz]

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.

"Paul Brady" <pt*****@aol.co mwrote in message
news:e1******** *************** *********@4ax.c om...

>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:Employee s.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\Frank enstein.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

[Salad]

Paul Brady wrote:

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:Employee s.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\Frank enstein.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 might consider using UNC naming conventions instead.
http://www.mvps.org/access/api/api0003.htm
You could even create a field in some table to store the UNC name for
the folder holding the pics.

You could enumerate the drives looking for EmployeeData\pi ctures\...and
hope nobody has a temp directory of the same name.

You could ask the folks to map to a particular drive.

Rainbow
http://www.youtube.com/watch?v=2A2Jt4WOxN8

[Paul Brady]

On Mon, 31 Dec 2007 17:34:31 -0000, "Baz" <ba*@nospam.now herewrote:

>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.

I think that will work, and I'll look into that when I get back to the
site later this week. Thanks.