• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

Access XP Hangs on Exit of Objects and Database

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
nouses9
Asked:
nouses9
  • 4
  • 4
  • 2
  • +1
1 Solution
 
shanesuebsahakarnCommented:
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
 
nouses9Author Commented:
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
 
shanesuebsahakarnCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
nouses9Author Commented:
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
 
shanesuebsahakarnCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
nouses9Author Commented:
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
 
nouses9Author Commented:
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
 
shanesuebsahakarnCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'd agree ...
0
 
CetusMODCommented:
Closed, 500 points refunded per request http:Q_21125084.html

CetusMOD
Community Support Moderator
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 4
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now