VB Code Disapears Sudenly

[Dany]

Hi everyone, It's Dany and I'm new here


In the last three months, I was working on a project using Ms Access 2007, and Few days ago, when I oppened the file, nothing was working. I checked out the VB Code and found that all were gone. I don't know what was the problem. I am trying to rewrite everithing, but it's realy boring.
Some one told me I should try "Compact and Repair".

Any help.

[RuralGuy]

I would start by importing this db into a fresh, new db and see if the problem follows.
http://www.btabdevelopment.com/ts/impnew

[Dany]

I will try it tonight

[SteveH2508]

Also check whther the file is in a Trusted Location

[Dany]

Last night I tried importimg forms to a new Db file, but nothing happens. Still all codes are missing.

What do you mean by "Trusted Location "??

[RuralGuy]

Last night I tried importimg forms to a new Db file, but nothing happens. Still all codes are missing.

What do you mean by "Trusted Location "??

Sorry to hear that.
Here's a link for TRUSTED LOCATION but I don't think that will help in this situation. Did you have any Standard Modules and are they gone as well?

[Dany]

What do you mean by "Standard Modules"? BackUps?

[Dany]

I Always wondered about That Security Warning, and how can I remove it every time I start the file.
What about It? and what do you mean by "check whther the file is in a Trusted Location check whther the file is in a Trusted Location"

I need to Set the folder containing the file as Trusted? What does this work for?

[RuralGuy]

Did you follow the link I supplied and set the Trusted Location as suggested? YES, the folder where your file resides needs to be trusted.

[Dany]

Did you follow the link I supplied and set the Trusted Location as suggested?

Yes I did it yesterday and The security warning is gone. But still no VB Codes.

[RuralGuy]

That sucks Dany! I'm out of ideas. Sorry. Backup...backup...backup.

[Dany]

That sucks Dany! I'm out of ideas. Sorry. Backup...backup...backup.

Lesson learned in a hard way.

[pkstormy]

If you find your vba code is suddenly missing (within a form or module), sometimes the culprit is having 2 versions of MSAccess on the same computer and you've imported a form/module from one accdb (or mdb) into another (without debug/compiling). Sometimes though the culprit is opening the same mdb/accdb with different MSAccess versions.

One way to recover a corrupted form which has lost all vba coding, is to open the mdb/accdb using the /decompile switch. Then delete the form and try re-importing it from a good source backup of the mdb/accdb. After importing, make sure you IMMEDIATELY debug/compile the mdb/accdb after importing (ie. DON'T make ANY coding changes after importing.) Otherwise you might be better off creating a new accdb and then importing all the objects from a backup.

For more info on the /decompile, see help or this post: https://www.accessforums.net/code-re...pile-8149.html

Unfortunately there really isn't a way to 'fix' a corrupt form which has lost all vba coding. It does suck though learning how important backups are (the hard way.) Before I update any coding, I always do a copy/paste of the mdb (which only takes a few seconds to do.) Although I rarely need to go to a backup, those few seconds will save me hours of work if need be.