Solved

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

Posted on 2014-09-11
9
330 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

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…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

911 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

21 Experts available now in Live!

Get 1:1 Help Now