[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Access XP Hangs on Exit of Objects and Database

Posted on 2004-09-01
11
Medium Priority
?
204 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
[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
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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
 
LVL 85
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 85
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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…

656 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