Something strange is happening...

[mreference]

My db is crashing a bit to regularly now and I don't know what to do, when it eventually goes live, if it crashes it is going to be a nightmare.

First error, I have a form that includes fields for firstname and surname for example. After creating a unbound text box to merge them together, the form displays perfectly. As soon as I delete the label, access crashes.

I tries the same in another form, the record displays, after deleting the label, this time it didn't crash but the unbound text box made itself invisible, the properties indicate that it is visible.

Then every so often after making changes to a form, I'll switch it to Form View, and access will keep it in Design Mode. When I try to close it down, it crashes. When I try to open the form, I get a message saying that there is not enough room to carry out that operation. I then have to import the form back through my backup. Which I am making quite a few times during the day now.

I followed Allen Brownes advice http://allenbrowne.com/recover.html but it continues to happen.

Am I doomed?

 

[gemma-the-husky]

try these

compact & repair
decompile

 

[mreference]

I've tried those and still keep on getting the same.

It's so weird but mightily frustrating at the same time.