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
Solved

MS Access form: Dlookup list doesn't show up anymore  for most users on Terminal Server, why?

Posted on 2014-09-11
9
334 Views
Last Modified: 2014-09-20
MS Access form: Dlookup list doesn't show up anymore in the main form  for most users on Terminal Server (2008 R2).
Only when the click on the position where it should be, it will show.
(So that's also the workaround)
Pressing F5 will maken them disappear again.

It didn't do this before.
We recently switched from 20007 to 2010. But at first no problem.
Also there might have been a change to the logon script, but that is a long shot.
I can't find any differences in the Options between the user where it works (namely me)  and those wwhere it doesn't work (everyone else, including admin).

Can anyone shed some lkight on this dark matter?
Many thanks in advance!
0
Comment
Question by:Timmeh
  • 5
  • 2
  • 2
9 Comments
 
LVL 35

Expert Comment

by:PatHartman
ID: 40317145
Are you all linked to the same BE?  DLookup() is getting data from a table.  If the table is different for you and your users, the results will be different.
0
 

Author Comment

by:Timmeh
ID: 40317190
the table is the same for everyone. it's a table inside the module.
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 40317311
Do you mean a table inside the FE?  If so, are you sure you are all using the same FE?  Make a visible change to the main form so you can verify that everyone is using the same copy.
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 12

Expert Comment

by:danishani
ID: 40317679
Do you have a backup in place? It might be best to either push-out a new FE from the backup, or try to repair the FE. I suspect that this is not normal behavior. Did you made some changes before this behavior?

My 2 cts.
0
 

Author Comment

by:Timmeh
ID: 40318841
Thanks for the replies  so far!
Everyone is using the same tables, forms and versions of the .accdb (I put in version numbers on the start up form).
I have 6 of them, each experiences the same problem.
I can't imagine they all corrupted simultaneously.
Now it also stopped working for me.
Which is actually a good thing: it means the problem is the same for all and therefor the cause of the problem and the possible solution.
Now if I only knew the cause :(
0
 

Author Comment

by:Timmeh
ID: 40318846
Attached a screenshot of the problem
Problem-DLookup-fields.JPG
0
 
LVL 12

Expert Comment

by:danishani
ID: 40319533
Ok it happens I am Dutch nationality, so I can even understand what's in the Form. :)

But back to the issue or cause. Its hard to tell what is the cause, but I still suspect some kind of corruption on that particular Form.
Did you made any changes on this Form before this behavior occurred?
Second and maybe most importantly do you have a backup of the Front End, so you can distribute a good working version to all of your users.
0
 

Accepted Solution

by:
Timmeh earned 0 total points
ID: 40324729
Solved!
Restarting both Terminal Servers did the trick!

Still not sure what caused it though.
My guess is, based on the log files, it has to do with the Print Spooler.
Only restarting Print Spooler didn't help.
I guess that an "overheated" Print Spooler disturbed something else as well, which could only be fixed by a restart.

Thanks anyway for giving this problem your attention and thoughts!
0
 

Author Closing Comment

by:Timmeh
ID: 40334206
The reason I accept my own comment as the solution is because it contains the solution.
I solved it myself and don't want to leave this question open and unfinished. That would be sloppy.
Not sure how to grade this though.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

789 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