Access 2003 SP3 + Hotfix KB837003 Crashing on form save

[Alec M1BNK]

Hi All, I have the following problem which I urgently need a solution for

I use Access 2003 SP3 + Hotfix KB837003 as a front end for a MS SQL Server
database because it's what I can do - complex VB front ends are currently in
the what I can't do pile.

I have problems with Access encountering a problem and having to close,
dumping the unsaved changes I have made to a form. No error messages are
displayed, and the "send error report" dialog doesn't bring up any web-pages
offering explanation or solution.

I can force this error by adding an option group to a form from the toolbox
and then saving the form. I can replicate this same problem using a new blank
access project, and also doing the same on another PC in another location.

Has anyone got any ideas how I might fix this. Have I missed a hotfix
somewhere?

 

[Klaus-Dieter Gundermann]

In article <[email protected]>,
(e-mail address removed) says...
/Push

I have the same problem too, with an Access XP database connected to
MS SQL 2005 server. ( All systems are regulary patched by our WSUS
Server .. )

I am trying Decompile / compact / repair (DCR)
and the error may ( or may not ) dissapear.

I even installed a VM only with Windows XP and Access 2007,
transfer the database to the VM do a
Decompile / Compact / Repair (DCR) with Access 2007
Open the Form -> Everything is fine,
Change the Form ( adding a combo box ) and Save -> Access Crashes

Delete the form from the database, do a DCR, import the form from an old
backup, now it may work, or it may crash, when I try to change the Code
behind the form.

Next try: delete Form, DCR, Import from old Backup, Form is OK,
I can change it and save it, but suddenly ANOTHER form Access crashes
when opening the form and filtering for data....

This random problems and crashes are driving me crazy !!!!!

And when the database is running fine on my developer system, it may
crush on SOME of our Users workstations, (sometimes when opening the
database, sometimes during operation )

I have tried everything from http://www.allenbrowne.com and other
Sources
- Decompile / compact / repair
- Switch off Name AutoCorrect
- Import all Queries/Forms/Reports in a new empty database
- Export Everything to a Textfile and Import in a new database

But these random errors always returns and are getting worse. Two years
ago I had maybe one Access Crash a month during development, but now I
have almost after every Change random problems in my application.
( And 60 !!! Access Crashes in this week )