Had an interesting bug in MS Access. Very complicated system with many forms started to crash Access on loading several of the forms. Mostly it affected my ability to update the system, but yesterday it became critical because some users could no longer work with it. I decided the database had to be corrupt so started from scratch, importing queries and code (things that were just text) and rebuilding the forms. Luckily for my use of time, Access crashed as I was adding a tweak to a field in pretty much the first real form. I had changed it from a text box to a combo box, displaying the name field from a personnel table instead of the ID. Realising I'd probably pinned down the bug, I created yet another new database, added just two tables, a form for one table and on it a combo box linking to the other table. Crash!
Amazingly, typing a basic description of that scnario into Google yielded several hits, pointing me to a Microsoft hotfix, kb945674. The description pretty much matched my experience. I downloaded and installed it and in the new database the problem went away. Unfortunately the "proper" database still crashes, probably because the buggy version of Access created the combo box. Oh well, at least I can rebuild it now.
Quite how Microsoft managed to break something so basic when releasing Office SP3 I don't know!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment