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

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!
TimmehAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
TimmehConnect With a Mentor Author Commented:
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
 
PatHartmanCommented:
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
 
TimmehAuthor Commented:
the table is the same for everyone. it's a table inside the module.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
PatHartmanCommented:
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
 
danishaniCommented:
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
 
TimmehAuthor Commented:
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
 
TimmehAuthor Commented:
Attached a screenshot of the problem
Problem-DLookup-fields.JPG
0
 
danishaniCommented:
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
 
TimmehAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.