Is Access 2007 buggy

[scooteman]

My company upgraded us this Fall to Microsoft 2007. I am building a database to track employee training and I have had several instances where form controls suddenly stopped working or just crashed Access totally. This morning it happened again.

I am at the point where I am populating the tables with test data to see if everything is working as expected. I have a form to setup mail merge data and on that form I have a "Create Label" button that opens the Label Wizard and it points it to the right query. I borrowed the VB code from the MS Office Contacts template. It was working perfect yesterday, but this morning when I clicked it Access crashed. It continued to crash Access even after Access tried to repair it. I found if I took out the On Error portion of the code that It stopped crashing my database. Then I remembered that when my other forms stopped working right I fixed it by merely renaming the form, open it up, close it, and then renamed it back to the original name again. I restored the original On Error code and then renamed the form. Now the form works again and my "Create Label" button is working like normal.

Are there errors that creep into the form when your building and adding controls that could cause these bugs. Does renaming the form clear some of these errors out?

I am just curios since I have ran into this problem 3 or 4 times since I started building this database.

 

[georgedwilkinson]

I'm not sure exactly but Pat Hartman gave some advice about a year ago concerning moving a form between design mode and form mode. She seemed to be advising that things could get corrupt if you change back and forth without saving/closing. Just in case that helps.

 

[scooteman]

I'm not sure exactly but Pat Hartman gave some advice about a year ago concerning moving a form between design mode and form mode. She seemed to be advising that things could get corrupt if you change back and forth without saving/closing. Just in case that helps.

That does help. That could be what is corrupting my forms. I was working on a button last night to checkmark all the visible records after a filter. I probably did go between design mode and form mode several times without saving as I was checking how my code worked.

Thanks for the tip.

 

[boblarson]

Also, make sure you do have SP1 and SP2 for Office 2007 installed. There were quite a few bugs that were fixed by them.

 

[georgedwilkinson]

Thanks for the tip.

No problem, glad to help.

 

[scooteman]

Also, make sure you do have SP1 and SP2 for Office 2007 installed. There were quite a few bugs that were fixed by them.

Yes, my computer at home and work are up to SP3.

 

[boblarson]

There is no SP3. Only SP1 and SP2.

 

[scooteman]

There is no SP3. Only SP1 and SP2.

I have XP and on the the system properties it says "Service Pack 3"

This link show SP3

http://technet.microsoft.com/en-us/windows/bb794714.aspx

 

[boblarson]

I have XP and on the the system properties it says "Service Pack 3"

This link show SP3

http://technet.microsoft.com/en-us/windows/bb794714.aspx

I was talking about OFFICE 2007 (not WINDOWS). What is your OFFICE 2007 Service Pack at? See here for how to see what revision level you are at.

 

[scooteman]

I was talking about OFFICE 2007 (not WINDOWS). What is your OFFICE 2007 Service Pack at? See here for how to see what revision level you are at.

Oops, my misunderstanding. MS Office Access says I have SP2

 

[boblarson]

Check this out and see if there is something that might help.

 

[scooteman]

Thanks Bob,

I am going do download some of the fixes and see how they work. Last night I compacted my database and I found three macros that were deleted. Two for opening reports and one for opening a form. Simple macros to redo but they were from three separate forms.