Solved

Access XP Hangs on Exit of Objects and Database

Posted on 2004-09-01
11
195 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
ID: 11954387
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
ID: 11954441
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
ID: 11954511
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
ID: 11955024
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
ID: 11955093
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 84
ID: 11955280
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
ID: 11956157
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
ID: 12017240
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
ID: 12017279
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
ID: 12017538
I'd agree ...
0
 

Accepted Solution

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

CetusMOD
Community Support Moderator
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

867 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

17 Experts available now in Live!

Get 1:1 Help Now