?
Solved

Lotus Approach database log on has become slow.

Posted on 2010-09-06
4
Medium Priority
?
1,492 Views
Last Modified: 2013-12-27
HI all,


Lotus Approach databases load very slowly and run very slowly on 2 out of a total of 33 Terminal Services Login profiles (running on Win 2008 server R2 64 bit on LAN )
 
This problem has emerged "out of the blue" on these 2 TS Logins, they were previously working OK until 4 days ago.  They still run all other programmes OK (MS Office 2010, Outlook etc).
 
Have tried getting round the problem by creating 2 new logins but they have both got the same slow loading / running Lotus Approach Database problem.
 
Any suggestions gratefully received.
0
Comment
Question by:gareth629
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 63

Expert Comment

by:SysExpert
ID: 33621978
What are the sizes invoved.  
Isn't it time to find an alternative by now, since this has probably been unsupported for years...

Does each login get access to different portions of the database or is it all the same ?

I hope this helps !
0
 

Author Comment

by:gareth629
ID: 33625551
Lotus Approach is running in terminal services.
 
There are a numer of separate databases - the data tables vary in size vary in size from 1MB to 200mb.  The database front end (.APR) files,  vary in size from 200 KB up to 2mb.
 
The majority of our logins are currently working OK it is just 3 that load and switch databases slowly.  The databases can be run as a separate shell for each database, or all databases in the same shell.
 
28 TS logins run Lotus OK.  3 TS logins run Lotus very slowly  I'm thinking that one of the 8 or so JET files, and associated ~XXXX files, in the Windows Temp folder may not be functioning normally and that may be the file being used by the slow Lotus running logins. Deleting all of these temp Jet files may forcing Lotus to re-write them - hopefully in a form that allows for all database logins to run normally.
 
All other services (Office/ Outlook etc) on these 3 logins run normally.
 
Any thoughts on the above gratefully received.
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 33629568
Are there particular databases that are slow ?
Are the other 25 users using the SAME DBs as the 3 that are having issues ?

I would definitely check the TS profiles and compare, but you said you created 2 new accounts.

Could this be computer related ( hardware ), have you tested on a different computer ?

0
 

Accepted Solution

by:
gareth629 earned 0 total points
ID: 33684198
They were on the same DB.

apologies for this, the customer has apparently fixed it but has not bothered to let me know how.

thanks for you help
g
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

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