DB Crash on Update

[GUIDO22]

I have this really frustratingly annoying problem with my DB. If I make a change to an existing form or report whereby I duplicate a text field or label / create a new text field but then delete the text label tag.... the database crashes.

I have even tried creating a new blank database , importing a single report from my original DB and making a change by way adding a text field and then deleting the label for the control, save then CRASH!..... why is this happening?

If the DB is reloaded and you attempt to open the form / report in Design View - Access will not permit you. It does nothing, almost like it does not sense the item exists at all!

I have done a recompile / repair etc. and all checks out correctly ie. seemingly no corruption or otherwise - but still this problem persists and makes carrying out a relatively simple change time consuming and frustrating.

(To get around the problem I have to add the text control and make its corresponding label invisible. Trouble is - with a few controls on the form, in Design view it can get quite congested....)


Any ideas would be greatly appreciated... thank you.

 

[dkinley]

I am not sure if this will help or not, it has helped me once or twice in the past, ... but have you decompiled the database to see if that does anything? If you never did this or not sure how - you can find some information here.

-dK

 

[Zigzag]

I have had this before with forms.
The trick is to not delete the label until you have closed the form and then reopened it.

 

[GUIDO22]

I have had this before with forms.
The trick is to not delete the label until you have closed the form and then reopened it.

Sure enough - this does actually do the job! Thanks!
(a bit of a fudge but in the absence of any other suggestions this will do!)
Cheers