Solved

Access application on Terminal Server

Posted on 2013-12-16
6
427 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
  • 3
  • 3
6 Comments
 
LVL 84
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 84

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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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 84
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Allow user to edit an outgoing email 2 25
Solved: How can I prevent deletions from a form in datasheet view? 5 27
update all email addresses SQL 1 23
Switch 5 16
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

770 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