Solved

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

Posted on 2014-09-11
9
339 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
[X]
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
  • 5
  • 2
  • 2
9 Comments
 
LVL 38

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 38

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

696 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