Urgent help needed

[OldManRiver]

All,

I have a FE/BE design in production. Last week the FE blew up on one of MS, memory collision errors.

Since then all my forms on the FE are coming up in either POPup or Modal mode. It is causing all the users to hang and not be able to run the processing.

I was able to clear this once, but clicking Yes on both these properties, then saving, then clicking No and saving again on my main Form.

Then we had a power outage and the FE got corrupted again and now I can not get these to run in normal mode. I tried the saves above and even did it on each individual form.

I have started a new db, 3 times and imported, trying to fix this but nothing is working. Need to recover from this ASAP.

Help desperately needed!

Thanks!

OMR

PS

Oh yes, when I do the save routine on the main form in the development mode, the problem clears, but "compact and repair" or "save and exit" the DB has the problem when it re-opens.

O

 

[boblarson]

1. See if any, or all, of this helps.

2. One more reason why we tell everyone to have a SEPARATE COPY of the FE on EACH user's machine and don't share a FE. If the FE corrupts EVERYONE can't work. If one on a user's machine corrupts you just replace it with a good copy and go on your way and everyone else has no notice of it not working for that other user.

 

[RuralGuy]

Don't you keep an original of the released db? If you did then you could just give everyone a fresh copy. Are you releasing an mdb or mde?

 

[OldManRiver]

Temp Solution

All,

I kept going back through my backups until I found where I no longer lock up and found it was when we implemented a splash login screen that things went south.

I disabled this for now, but have done this many times without this result, so now my question is why?

Any suggestions?

OMR

 

[boblarson]

Re: Temp Solution

Any suggestions?

Corruption can be hard to pin down. But, make sure your users use a copy of the FE on their machine and keep your development copy separate from anyone using it for production. Then if anything happens you can recover faster.