[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Access 2003 freezing up on Terminal Server 2008 R2

Posted on 2016-10-12
8
Medium Priority
?
55 Views
Last Modified: 2016-10-22
Situation: Access 2003 MDE front end application running in a multi-user terminal server 2008 environment accessing back-end SQL Server 2008 DB. RDP sessions initiated from workstations inside the network result in the Access application window turning white and becoming unresponsive after any interaction with the Access UI. Sessions initiated from outside the network still work normally - using the same terminal server and the same application.

I tried a bare-bones Access session using the native interface on a single ODBC linked table with the same results - a table SELECT statement returned the expected data but when I attempted to interact with the datagrid Access froze.

The event log provided very little: The program MSACCESS.EXE version 11.0.8321.0 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.

Question: What are some likely candidates that may cause this sort of behavior? Access itself still seems to be working with the remotely initiated sessions and it is at least displaying returned data before freezing up on the locally initiated sessions. Can the RDP protocol itself be causing the problem? How about graphics drivers on the terminal server?

I can try to supply additional information if needed.

Thanks
0
Comment
Question by:kkamm
  • 4
  • 3
8 Comments
 
LVL 20

Expert Comment

by:John Tsioumpris
ID: 41841365
How about a session with mdb...to get a better info of what is going on...
Also have you restarted Terminal server...?
0
 
LVL 59
ID: 41841758
<<inside the network result in the Access application window turning white and becoming unresponsive after any interaction with the Access UI. Sessions initiated from outside the network still work normally - using the same terminal server and the same application.>>

  Just to be clear on the problem; are the inside users also doing a RDP session?  or do they have the apps installed on their station and are just hitting SQL?

 A white screen BTW in of itself means nothing other than you should wait.   When Access executes a query against SQL, it does so synchronously and will stop processing until it gets a response.   That means screen paints might not even occur and you'll get a white screen.

 If the users are just hitting SQL, then it would indicated that you have issues with your SQL protocol's and/or network internally.

Jim.
0
 
LVL 1

Author Comment

by:kkamm
ID: 41841910
John- Rebooted last night to no avail.   I tried a new MDB with a single ODBC link (same DSN as affected app) to one table in the DB. It pulled the data but froze as soon as I tried to interact with Access.

Jim- RDP for both internal and external conx. Internal users connect both with a local application installed on fixed workstations and via RDP for special cases (laptops not joined to the domain). We were looking at our AV solution (Symantec Endpoint) to see if it was interfering and added some exceptions but it didn't change anything.

There were a few Windows updates that occurred since the application last worked  so we are going to uninstall the updates to see if that helps. .NET 4.5 was also installed so we are going to roll that back as well.

I am leaning in the direction that it is a network issue and not an Access issue.
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.

 
LVL 59

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 41842060
<<I am leaning in the direction that it is a network issue and not an Access issue.>>

 First thing I would check is the protocols SQL has loaded for communications and their sequence (TCPIP, Shared Memory, Named Pipes, etc), vs what the work station has.  If they are not in the same sequence, slowdowns getting a connection to SQL server can occur.

 This is in SQL configuration manager.

 Also, make sure that ODBC connection pooling has not been turned off (this is in ODBC admin applet).

Anti-virus is a good thought and it's simple enough to check (just turn it off for a bit), but usually that's on open of a DB and not a problem after it's running.

 After that, it's a network issue of some type.  If the App works fine for TS users, then it's not Access or the APP.

Jim.
0
 
LVL 59
ID: 41842070
One other thing: I'd do a spot check of the event logs on one of the stations and the SQL Server box.   See if there are any errors related to SQL, networking, or security.

You can get some weird stuff just with clocks being off if your using trusted connections with SQL.

Jim.
0
 
LVL 1

Author Comment

by:kkamm
ID: 41842300
Jim,

Thanks. I'll check each of those items.

On a lark, I tried using the Remote Desktop Client app from the Windows store instead of mstsc.exe and the freezing stopped.  It may end up being part of the solution but it doesn't explain why the default mstsc.exe client freezes so I am looking at this as a workaround to buy time to check the items you have listed.
0
 
LVL 1

Accepted Solution

by:
kkamm earned 0 total points
ID: 41847400
After installing the newest version (v893) of Microsoft Remote Desktop on the affected machines we managed through a heavy shift without an application freeze. The common denominator was they were all running Windows 10. Even though I don't have a specific reason why mstsc.exe started behaving like this I have no reason to return to it as the newer client is faster and scales better.
0
 
LVL 1

Author Closing Comment

by:kkamm
ID: 41855088
Changing the RDP client solved the immediate problem but I will be using the assisted solution to troubleshoot further.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Implementing simple internal controls in the Microsoft Access application.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

607 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