Solved

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

Posted on 2014-09-11
9
328 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 34

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 34

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
 
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

759 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now