Why does form crash navigating records?

N

NewSysAdmin

I recently started using the Auto FE Updater, designed by Tony Toews (THANK
YOU TONY!!!!!), with a database. Previously I had been sharing the front end
from the network and knew there was a large possibility of corruption with
that setup. I'm still working out the bugs.

One strange thing I've run into is that on only one PC, when opening the
form in edit mode (from Switchboard or otherwise), and then trying to go
through old records, the form crashes and crashes Access 2003.
It seems that it is not reading the table correctly. Several of the field
values are mixed up.

I've tried logging in as myself (admin) on that PC, and it still crashes.
I've reinstalled and updated Access. I've also done Compact and Repair, as
well as recreating the shortcut for the auto fe updater. Nothing has helped.

What could this mean? Is it possible the form or entire database is
corrupted?

Thank you for any suggestions.
 
N

NewSysAdmin

Well the PC had SP3 but not the hot fix, but now it does. However, that did
not fix the problem.

I was able to fix it by simply copying the form and then renaming it. I
didn't make any changes to the form, but now it is working.

Is it still possible the form may be partially corrupted? Should I consider
rebuilding the form? If so, could I just copy the controls and code to a new
form, or would I need to rebuild from scratch? Or maybe I should just leave
it alone?!

Thank you.
 
R

ruralguy via AccessMonster.com

Doing a /decompile helps.
http://www.granite.ab.ca/access/decompile.htm

Also just import the db into a fresh db and then do a Compact and Repair.
Often any corruption does not import with the rest of the db.
Well the PC had SP3 but not the hot fix, but now it does. However, that did
not fix the problem.

I was able to fix it by simply copying the form and then renaming it. I
didn't make any changes to the form, but now it is working.

Is it still possible the form may be partially corrupted? Should I consider
rebuilding the form? If so, could I just copy the controls and code to a new
form, or would I need to rebuild from scratch? Or maybe I should just leave
it alone?!

Thank you.
Does that PC have Office 2003 SP3 installed and the HotFix that goes with it?
http://support.microsoft.com/kb/945674
[quoted text clipped - 20 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top