Solved

How do I get an old access 2003 database to work on both my terminal servers

Posted on 2013-11-22
5
256 Views
Last Modified: 2013-12-14
Good evening experts,

I have yet another terminal server issue to resolve. I have two terminal servers that have presumably been configured as round robin. I say presumably because I didn't set this environment up. Here is my issue. One of our vendors is no longer with us and I have inherited an access database from 2003 from said vendor. On one of the terminal servers it works. I should have added that the database was an attempt at a enterprise purchase order system , but morphed into other functionalities, but I digress.

Below is a set of pictures depicting the process of  how the database functions on terminal server  VMS-2008-TS3:

Terminal Server VMS-2008-TS3

!
Launch Clubware (2003 Access Database)

!
Inside database app with tabs including the purchase Request tab.

!
Purchase Request View

!
Print Preview of the Purchase Request

!
Selecting Print Option

!
Choosing PDCreator Printer

!
Select  Save

!
Save to the Pending Purchase Order folder with appropriate name.

!
That's it. Works like a charm on Terminal Server VMS-2008-TS3

but when I get logged onto Terminal Server VMS-2008-TS4 , here are the symptoms:

 VMS-2008-TS4

!
Launch Clubware

!
errors out

!
Windowed error

!
Full Screen Error

!
Knowledge base article 28306

!
Symptoms

!
Cause and Resolution ( I need help interpreting this). (solution, solution, solution, please).
I am stumped.

!
so , this is my dilemma experts. Please help me provide solution to my user base until I can get rid of the access 2003 database.
0
Comment
Question by:BLACK THANOS
  • 3
5 Comments
 
LVL 24

Accepted Solution

by:
Sandeshdubey earned 150 total points
ID: 39670931
See below link if it is helpful.
http://support.microsoft.com/kb/310803
http://support.microsoft.com/kb/160870
http://support.microsoft.com/kb/283806

Also if still the issue persist its worth contacting the application vendor for the same for faster resolution.
0
 
LVL 9

Assisted Solution

by:VirastaR
VirastaR earned 350 total points
ID: 39671689
Hi,

Please check this

http://www.access-diva.com/d5.html  - it can walk you through Solution provided in KB 28306

Additional Reference : http://answers.microsoft.com/en-us/office/forum/office_2007-access/error-the-expression-on-load-you-entered/d951ae11-8f74-4831-ae61-82286c9a03ff

Hope that helps :)
0
 

Author Comment

by:BLACK THANOS
ID: 39672095
Keep in mind that the vendor that built the access 2003 database is no longer with The Boys & Girls Clubs of Monterey County and they will not support the database any longer, so I am on my own with this. If I try some of the solutions you experts suggests , I want to ensure that first I backup the Terminal Server that has the errored out instance of access 2003 , thus preventing the creation and printing of simple purchase orders. All of my servers are VM's via VMware with EMC2. Is there an easier way to fix my issue without implementing the suggested changes above or at the very least an easy way to recover if something else breaks. I don't want to have to restore the entire terminal server VM without having tested my restored?
0
 

Author Comment

by:BLACK THANOS
ID: 39693845
I will be into the possible solution stated above in this thread tonight. I am unsuccessful, I will let you know.
0
 

Author Closing Comment

by:BLACK THANOS
ID: 39719553
Sorry for the delay , but KB 28306 seemed to do the trick when I followed the walk through
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Let’s list some of the technologies that enable smooth teleworking. 
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…

920 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