Viewing documents where the current user equals the user name in a specified field

Posted on 2003-03-30
Medium Priority
Last Modified: 2013-12-18
Ok, I think I am going mad over this one. I am trying to create a view where the current DB user sees all the documents where their username is listed in a specified field within those documents. This is my view selection:

SELECT (@name([CN];@username))=(@name([CN];selecttitle_10))

Selecttitle_10 is a name field.

Now, it seems to work, but, when I switch user IDs and select that view again, it displays the previous user IDs documents ather than the current user ID's documents. I have to go into design, refresh the view using the curly thing at the top left, close and save it and then the view is updated with the new user IDs documents. This is a bit frustrating, it's as if the view is not refreshing when the DB is accessed by a new user.

Anyone got any idea's of what I am doing wrong or am I just expecting too much?

Question by:pmakar
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
LVL 31

Accepted Solution

qwaletee earned 200 total points
ID: 8236701
Create a new view, type private-shared on first use, copying the design from the current view.

Your problem is that when you opened the view for the first user, the server built a new view index based on teh current user.  That index is shared by all users who enter the view.  Think about it -- for the "other views" in the database, it would be wasteful to have to build the view separately for each user, right?

That's just what private on first use is for -- each user gets their own index just for the vews where it is needed.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question