access database crashes ...

[acteck]

Hello! I know you'd probably suggest: use search and you will get your answer
I have searched and i could not find the one which will solve the problem.

So, here is the problem:
I have Microsoft Office 2010 32 bit installed on Microsoft Windows 7 Prof 64 bit
the database is accdb. Recently (one week or so ) i have started experiencing database corruption error: i cannot open any form , report or vba module, tables are still accessible though ,most of the linked anyway to SQLDB. So i had to create back up every one hour otherwise i have to redo all the work all other again. I have tried to create the new empty file and import everything from the backup and apply all the changes but after one day or so it is happening again! So it goes like that: i restore it from the backup, apply changes , all good, but as soon as i close it to create another back up and open again it already corrupted. It would be greatly appreciated if anyone know how to fix that! Thank you!

 

[PNGBill]

Checkout the issue on Microsoft's web site.
I had to do a Decompile regulary and ended up with a shortcut to click on to do this.

Decompile seemed to resolve the issue, until next time but it has settled down somewhat.

Here is the shortcut used for my decompile

C:\RaglanClubGroup\DatabaseMYOB\ClubFinanceDatabase\cfdatabase2010.accdb /decompile

Path to frontend\filename /decompile

 

[acteck]

i will try using decompile switch. Based on your suggestion i have looked up and found this:
(apparently i cannot add link to my post, so office_2010-access/access-2010-sp1-you-receive-random-crashes-in/d2bf6175-075a-4a12-a2b1-f55d40af271b )
so, It looks like the reason is Microsoft Office 2010 SP1

Thank you for your help!

 

[PNGBill]

Not a link. That is the shortcut path.

You could go to Start, Run, cmd, Enter
Then type the path above ie.

Path to frontend\filename /decompile

What I posted was my path to front end. Yours will be what ever it is.

Because I had to do it so many times, I just pasted it into a short cut on my desk top.

Double click the shortcut and Wala, your front end has been decompiled.

Then open the fornt end and Compile on vba and all should be ok or not

Make a copy first.

 

[acteck]

I have understood about command line switch /decompile.
but what i meant that i found the article in Microsoft web site and it says that the reason of crashes is Microsoft Office 2010 Service Pack 1
so i am going to uninstall it and will check if problem will be resolved

 

[PNGBill]

I would copy the database and decompile before uninstalling sp1.

I haven't needed to decompile for sometime. It seemed to settle down after a while.

 

[acteck]

It is been several days since i have uninstalled SP1! So far so good!

 

[PNGBill]

Good news