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
.

Relevant Pages

  • Re: Identifying individual users who all use a shared access database.
    ... specify the full network path of the folder instead of a mapped drive. ... resides on a network server. ... Andrew's computer sees the path to the picture folder ...
    (comp.databases.ms-access)
  • Re: Image names sorting in Insert Images ?
    ... >Right click Folder DetailColumns select Modify and clear the Value data entry ... >Close regedit and relaunch FrontPage and see if it now works. ... Another interesting fact..if I browse (from Insert Picture) to ... the same folder on the server via a mapped drive, ...
    (microsoft.public.frontpage.client)
  • Re: web space. advice and help please
    ... The following is an extract from the BT page for webspace, and it seems to answer for my needs? ... You need to to the picture in your 'index' folder on your server. ...
    (uk.people.silversurfers)
  • Re: create filesystemojects permission denied
    ... When you try to create a folder in 'remote' ... > trying to create a folder on a network server. ...
    (microsoft.public.inetserver.iis.security)
  • create filesystemojects permission denied
    ... trying to create a folder on a network server. ... developing this ASP application on my local web server I ...
    (microsoft.public.inetserver.iis.security)