Solved

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

Posted on 2013-11-22
5
261 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
In-place Upgrading Dirsync to Azure AD Connect
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

809 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