We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Microsoft Access Generating Tmp File

Medium Priority
1,177 Views
Last Modified: 2013-11-29
We are accessing a database using Microsoft Access 2003 on a Terminal Server. On the Terminal Server when we generate a report it takes a long time to get the results yet the very same report on a workstation is fast. With Filemon (Systermals) running on the terminal server we see that there are hundreds of writes being done to the local user profile creating a JETE917.TMP file. This turns out to be a zero byte file. This file is not created when the same process is run from a workstation. Looking for clues to why this is happening on the terminal and not on the workstations. It is severly impacting performance on the terminal server. The terminal server is also running Access 2003 on a Windows 2003 Server environment.
Comment
Watch Question

Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Fortrak,

You have left out a great deal of info on this setup.
For example:
"it takes a long time to get the results yet the very same report on a workstation is fast. "
If the DB is local on the workstation, then it will always be faster the TS.
How fast is your network?
Is this the exact same database file(s) used in both tests?
Is the database "Split"? If so, where is the back end and where is the front end.

Thanks

JeffCoachman

Author

Commented:
Gigabit network. FE is on the workstation and local on the terminal server for the users there, BE is on the network. Exact same database in both tests. The configuration is identical on the workstations as on the terminal server. The main difference on the terminal server is that it is writing to a Jet temp file in the users profile hundreds of times during the query while on the workstation it is not. I suspect it has something to do with the way a terminal server manages Access in a multiuser environment like terminal services?
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Your Spec and configuration seem OK.

I am not sure about the temp file though, we run Citrix where I work.

But today many of the Experts will be back from the extended US weekend.

So let's wait for some more input...

;-)

Jeff

Author

Commented:
I ran Filemon on the terminal server again and took a screen shot (attached). You can see here that Access is writing to the Jet temp file in the local user profile thousands of times. Needless to say this is severely impacting performance. This does not happen at all on a workstation as mentioned earlier.
JetTmp.jpg
Commented:
Created a Microsoft support case on this and after a few days we found the solution to the problem in a hot fix released for the Jet 4.0 database engine. Applying the hot fix from KB954193 solved the problem and the Jet no longer makes thousands of writes to the temp file. Performance improved significantly.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Congratulation!
;-)

Jeff
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.