Solved

Access application on Terminal Server

Posted on 2013-12-16
6
453 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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.
Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime is disastrous for companies and can lead to major hits on a brand, reputation, an…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

730 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