Solved

Access application on Terminal Server

Posted on 2013-12-16
6
459 Views
Last Modified: 2014-01-28
Hi,

We have several Access applications running on a client's terminal server.

Windows Server 2008 R2 Enterprise
Access 2010

Every couple of weeks, Access seems to act up and the IT team has to do a re-install to correct the issues. When we go to delete objects (forms/reports), we confirm the delete, but they are still there. We have close and open the application again to see that they have been removed.  Also we can not always navigate between views (ie form view / design view). The functionality is greyed out in the ribbon.

Has anyone run into these issues before?

A re-install does solve the problem, but there seems to be a bigger issue since we have to keep re-installing the program every couple of weeks.

Thanks for your time :)
0
Comment
Question by:S_Hamel
[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
  • 3
  • 3
6 Comments
 
LVL 85
ID: 39722806
When you say "reinstall the program", do you mean you have to reinstall Access, or you have to "reinstall" your Access database?

If you've got to reinstall Access, then I'd suggest there is something wrong with the Terminal Server. Access/Office should not require regular reinstalls unless something else is happening (i.e. power surges, power cycles, etc) - and your server logs should tell you this.

If you mean your Access database has to be "reinstalled", then that could be caused by a number of things. For example, is the database split into a Backend (the tables only) and a Frontend (everything else), and does each user have their own copy of the Frontend?

Is the database hosted directly on the terminal server machine, or on a network share? It really should be hosted directly on the machine.

Sometimes maintenance needs to be done to your database - for example, create a new, blank database and import everything into that database. This tends to remove corruption, although you sometimes must take additional steps.
0
 

Author Comment

by:S_Hamel
ID: 39722841
Thank you for the reply.

Access has to be re-installed/repaired. Not the actual Access database.

I'm not positive if it's installed on the machine or share. I will have to ask the IT department.
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 200 total points
ID: 39723018
Access has to be re-installed/repaired
That's a problem with the installation of Access/Office on the TS, or a problem with the installation of the Operating System. Access should not have to be repaired each time.

Is 2010 the ONLY version of Access on the TS box? Multiple versions of Access can cause all sorts of issues, especially if they are run concurrently.
0
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 

Author Comment

by:S_Hamel
ID: 39815656
I though we had the issue under control after a full re-install of Office, but it has happened again.

The only other reference online I can find is here: (scroll down to the posts starting Jan 7, 2014)

http://social.msdn.microsoft.com/Forums/en-US/1701369c-02b4-4f43-abe7-03b099b4d517/access-2010-form-fields-not-calculating-until-clicked?forum=accessdev

I have had this happen in our dev environment on our own server, plus client's servers.
0
 
LVL 85
ID: 39816313
As was indicated to you in the link, there is very likely something wrong with the combination (OS + Office combo, that is). I don't think there is much we could help with on that.
0
 

Author Closing Comment

by:S_Hamel
ID: 39816326
Thanks Scott. There is no definite solution right now, but your response pointed me in the right direction. I will post any updates as I come across them for future reference.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.
During and after that shift to cloud, one area that still poses a struggle for many organizations is what to do with their department file shares.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

729 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