Extremely strange behaviour of Access overnight

[Thomasso]

Hello,

I was working on my Access application yesterday (backend is Microsoft SQL). I created a couple of forms, did some design changes in the forms, then some coding... Everything worked great, so I turned the PC off and was looking forward to continue working on it today.

But, when I came to the app this morning, some very strange things are happening:

• The forms I created are no longer there... But in VBA Editor, the class objects of those forms are there! However, if I click:
  
  • "View code": Error accessing file. Network connection may have been lost. (needless to say, I can open any other class/module)
  • "View object": Form doens't exist
  
  
• If I try to create the form again with the same name by:
  
  • Copying another form (similar one, like I did yesterday): Nothing happens. No error message, form doens't get created (it does with a different name)
  • Creating a new form from scratch - it DOES create with the same name. I can work with the new form, but if I try to get into the code (for example create "On Current Event", I get the same error: Error accessing file. Network connection may have been lost.

Furthermore, the design changes I did in some other forms seem to be broken (something stayed, something didn't).



I tried "Compact & Repair" that didn't help. I checked the save date of the accdb file from my backup drive, it says yesterday 5:20 pm, when everything was working fine...


What in the world is happening here???

[CJ_London]

If you turned the off without saving your form design changes, it may be corrupted.

create a new db and import what you can - each type at a time tables/queries/forms/reports

[Thomasso]

If you turned the off without saving your form design changes, it may be corrupted.

create a new db and import what you can - each type at a time tables/queries/forms/reports

Thanks, I will give it a try, but honestly it's quite a big app (over hundred objects), so this will be a pain in the ass.

It definitely shouldn't be that easy to get it corrupted (just because someone forgets to save). That really tell you something about Access, doesn't it...

[CJ_London]

That really tell you something about Access, doesn't it...

Yes - it is a much more complex and dynamic application than the other office products and should be treated as such.

this will be a pain in the ass.

Assuming your db is split so all you are importing is the linked tables and not data, the other objects will take a couple of minutes at most. If you have corrupted forms they probably won't import so don't import them on 'first pass'. Do them on a second pass.

[Thomasso]

Yes - it is a much more complex and dynamic application than the other office products and should be treated as such.

Haha, that is one very diplomatic way of saying that it needs some serious work.

[davegri]

Give this a try:

Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption (fmsinc.com)