We help IT Professionals succeed at work.

Project crashes on form refresh

peakoplant
peakoplant asked
on
442 Views
Last Modified: 2008-03-22
Hi, I have an Access MDB project front end which, using linked tables, accesses another back end MDB file. The program was being used in a Windows / Office 2000 environment and an XP / 2003 environment

The problem I am having is that on a particular form, when i press 'refresh' or carry out any task that involves the refresh of the form, the whole thing crashes and says the following...."Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience." It provides the option to repair and reopen the database with a check box but this does nothing.

This error DOES NOT occur when it is run in Windows 2000 / Office 2000, it only happens in XP / Office 2003. Another side effect of the switch is a vastly increased load time in XP / 2003 when in 2000 it was fine.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
did you try copying the front end used in Office 2000 and run in the Xp/2003 environment?
does it still crash?

was Service Pack 3 installed on the Office 2003?

Author

Commented:
Hi, yeah i tried copying it to no avail, installing service pack 3 was the last thing i tried unsuccessfully before posting. Thanks
CERTIFIED EXPERT
Top Expert 2016

Commented:
actually, installing SP3 was not a good idea, Sp3 still have a lot of unresolved issue but since you already install it (you can not uninstall SP3 - the only way to remove it is to uninstall office2033).
uninstall office2003 (your Access program might be damaged) and reinstall up to SP2.

good luck

Author

Commented:
well we have a few machines with the same problem but i only installed SP3 on to one of them but they all still have the same problem. Incidentally, having just checked, we have a speed issue on all projects, not just this particular one where by a project will take an age to load?
CERTIFIED EXPERT
Top Expert 2016

Commented:
where is your backend located? in a server?
this could be a network issue you are having. check with your IT guys regarding this.

if you can access the backend.
do the following
Compact and Repair the database
if the problem does not go away (that is after the network guys confirms that there is no problem with the network)

try decompile
see this link
http://www.granite.ab.ca/access/decompile.htm

Author

Commented:
thanks, i will look in to it.

Author

Commented:
Hi, i have tried all of those things with some success, the decompile and compact and repair have gone some way to address the speed issues however the project still crashes when i refresh the form in question.

The form is part of a stock control system which has 3 subforms on it for 'parts', 'labour' and 'miscellaneous' costs. The main form then calculates the total price values for each section using SUM and DCOUNT functions and then a grand total for the job by simply adding the 3 text box values together. It is when it is calculating these values that it crashes

Having investigated a little further it seems it only crashes when the subforms included on the form are fairly well populated therefore the calculations higher. It works fine on jobs with no records to calculate!!

Thanks, Steve
CERTIFIED EXPERT
Top Expert 2016
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
Hi Everyone,

I ran into this same issue and found a solution on microsoft.com:
http://support.microsoft.com/kb/945674/

It's a Hotfix for SP3, which causes all kinds of errors, and seems to fix the issue (for me at least)

Good luck!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*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.