Re: Identifying individual users who all use a shared access database.

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: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 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\pictures\...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

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

Re: Identifying individual users who all use a shared access database.

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 \\\, and will be the same from
any computer on the network.

"Paul Brady" wrote in message
news:e18in35ib2e7ormn0h61gelqp0tasd69kl@4ax.com...
>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

Re: Identifying individual users who all use a shared access database.

On Mon, 31 Dec 2007 17:34:31 -0000, "Baz" wrote:

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