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 3 2086
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
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
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Wayne Aprato |
last post by:
I have several Access 97 databases which are split into front end and
back end running off a server. The front end mde is shared by 2 or 3
- absolute maximum of 6 concurrent users. This scenario...
|
by: Hannu |
last post by:
Hi.
In the ldb file you can see the users of the mdb-file. If you open the
mdb-file your machine and username will be written in the lbd- file.
Allthough you close the mdb-file your name won't...
|
by: Ant |
last post by:
Hi
I have an Access 97 database sitting on a shared drive on a server, users
have various versions of Office (2000 & 2003) they all need to be able to
see the tables in the 97 application...
|
by: seansan |
last post by:
Another Q,
Because we sometimes need to repair the shared database I would like
to find out if there is a way to "kick" all users from a database. The
problem is that I cannot repair the...
|
by: Goran |
last post by:
How many users can access to SQL server at the same time with web aplication
written in C# 2005? What if my database is 1GB and 1000 people access at 1
second - some simple query. My web hosting...
|
by: NewtoAccess |
last post by:
Hi,
We have a shared Access 2000 database shared among many users within the company I work for.
many times, users open up the shared database and forget to close it.
So I cant even make...
|
by: theProfessor |
last post by:
We are using a shared split database with all users currently using
Access 2003. The back end is on a shared drive of a state wide WAN.
Each user has a copy of the front end on their local...
|
by: beacon |
last post by:
I'm having some trouble with my database (what's new, right?) and an error message that seems to appear somewhat randomly for the users that are accessing it.
I'm using Access '03 and know it...
|
by: themastertaylor |
last post by:
I have developed a database, split it, loaded the back end onto a
shared folder on the network and placed a copy of the front end on
each user's pc. the database is set to open in shared mode,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |