Save Button Closes my Database

[dwichmann]

I have an access 2003 database that we use to control orders for production and amongst other things also produces order acknowledgements. When inside the order acknowledgement form you have the option to select the name of the person sending the order from a combo box. Once you have selected the name you need to click the save button (standard access save button added via the wizard). This should update the order and allow you to print your order acknowledgement. For some reason in the last few days, clicking the save button has caused the access database to crash. I have tried putting break points in the code to find out why but it just crashes without launching vba. Anyone heard of this before?

 

[RuralGuy]

Sounds like you might have some corruption. Have you tried importing everything into a new empty db? How about /decompile?

http://www.granite.ab.ca/access/decompile.htm

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit