Solved

Access application on Terminal Server

Posted on 2013-12-16
6
411 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…

914 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

17 Experts available now in Live!

Get 1:1 Help Now