By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,854 Members | 2,015 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,854 IT Pros & Developers. It's quick & easy.

Identifying individual users who all use a shared access database.

P: n/a
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
Dec 31 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.comwrote in message
news:e1********************************@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

Dec 31 '07 #2

P: n/a
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
Dec 31 '07 #3

P: n/a
On Mon, 31 Dec 2007 17:34:31 -0000, "Baz" <ba*@nospam.nowherewrote:
>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.
Dec 31 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.