Solved

Access XP Hangs on Exit of Objects and Database

Posted on 2004-09-01
11
194 Views
Last Modified: 2006-11-17
Hello everyone,

I'm not sure if this is the correct subject area to post in, but I figured I would start here.

I have numerous Access XP databases that are stored on a server in a shared folder.  Most of the databases contain tables that are linked to other Access tables or SQL tables.  As of late last week, all of my databases are hanging when you open certain objects (usually forms or reports) and when you exit the database.  Eventually, the request will be processed and Access will do what you asked, but you have to wait anywhere from 30 seconds to 2 mintues.

I have tried all of the following to resolve the problem:
(1)  Installed Office XP Service Pack 3
(2)  Checked the client and the server for viruses and spyware
(3)  Moved the databases to a different physical server
(4)  Compacted and repaired Access databases
(5)  Reindexed the SQL tables

If I move a database that has no links to my local machine, the issue goes away.  If I move a database that contains links to other databases to my local machine, I have the same problem.  I am starting to wonder if the problem is network related, but everything else is fine (Internet browsing, accessing other types of office documents, etc.)

At this point, I am looking for any suggestions that anyone may have...

Thanks,
Susan
0
Comment
Question by:nouses9
  • 4
  • 4
  • 2
  • +1
11 Comments
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
I would agree that the issue could be network related. Have you tried opening one of your other databases across a network?

Also, have you tried this on other machines? Do they exhibit the same symptoms? Does it happen for all databases, or any databases linked to that particular SQL Server?
0
 

Author Comment

by:nouses9
Comment Utility
We open all of our databases across the network and that's when we have the issue.  If I copy a database to my local machine (provided that it doesn't have any linked tables), it seems to function properly.

This is happening on all of my machines and it happens for all databases when they are opened across the network (whether they contain links or not).  Unfortunately, we only have one SQL Server so I can't check to see if it only happens for a particular server.  However, if I connect to the SQL Server tables through Enterprise Manager across the network, I have no issues.

We are a very small office, therefore we only have one switch, so I can't even narrow it down to a particular network segment.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
Hmm - what happens if you create a new DSN and a new database using that DSN? Does that still have the problem (I suspect it will). Is your switch showing a lot of network collisions?
0
 

Author Comment

by:nouses9
Comment Utility
You were right, I created a new DSN and a new database using the new DSN and I still have the same problem.  Even if I create a new database on the shared drive that is not linked to any other sources, it hangs when I exit the database.

I must apologize, although I am responsible for the network hardware, I don't do a lot of troubleshooting or configuration.  What is the best way to check for collisions?
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
There should be a light on your switch that indicates this - monitor it to see if it is flashing a lot. Out of interest, if you run your database on the server itself, does it still exhibit the same problem?

You could also try updating MDAC (to 2.8) and Jet (to SP8) as well, to see if that helps.
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 84
Comment Utility
As shane suggests, this is almost certainly a hardware issue ... and since it happens regardless of where your "frontend" resides, it would have to be something common to all - in other words, either the server NIC, the switch, or a common cable. If shane's suggestion of running the app directly on the server solves the problem, then change out any common cables (i.e. ones between the server nic and switch, etc) first, and if that doesn't solve it, you may want to swap nics in the server. A note of caution - use the same brand of nic as is currently installed, if possible. Occasionally, mismatched nics can cause problems as well.
0
 

Author Comment

by:nouses9
Comment Utility
Running access directly on the server does solve the problem.  All of the databases run perfectly.  I am going to try all of your suggestions and get back to you.  It may take some time because I may need to get a replacement NIC or check the switch.  I will post updates as I have them.  Thank you for helping me to troubleshoot this problem.
0
 

Author Comment

by:nouses9
Comment Utility
OK, I finally figured out the problem.  It was the anti-virus software that is running on the clients.  We use Sophos anti-virus and in the configuration of the client, there is a check box that says Exclude checking of remote files.  I did not have that checkbox checked, therefore the agent was checking all files as they were being written causing the application to hang.  I called Sophos about this because it was not a problem prior to last week.  I was told that enhancements had been made to the part of the software.  Thank you to everyone for your help.

I'm not really sure how to assign the points for this one.  All of the suggestions were great and I want to be fair, but don't want to accept an answer that didn't solve the problem.  Please advise.

Thanks,
Susan
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
It's entirely up to you - I don't really mind either way. It might be worth getting a moderator to PAQ this question and refund your points as your solution might be useful to someone with the same problem.
0
 
LVL 84
Comment Utility
I'd agree ...
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
Comment Utility
Closed, 500 points refunded per request http:Q_21125084.html

CetusMOD
Community Support Moderator
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

763 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

11 Experts available now in Live!

Get 1:1 Help Now