Rabu, 18 April 2012

[MS_AccessPros] Re: HELP! My accde file lost vba functionality.

 

Liz

Take a deep breathe.

Oh, let it out.

Is the folder a trusted location? Check it to make sure. If it isn't your code won't run.

If it is, use the decompile switch to decompile your .accdb file. The easiest way to do that is to create a desktop shortcut with the full path of your MSAccess.exe and then add the switch.

Example (all one line with space before /decompile:
Target: "C:\Program Files\Microsoft Office\Office14\msaccess.exe" /decompile

Make a backup copy of your accdb just in case. Now drag your accdb to the shortcut. When it opens compact it and close it.

Open the accdb the regular way and make a new accde.

That work?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> I've been compiling out my accde to accde to the same folder for years, and for some reason today I can't get any of the code for the accde to run.
>
> Liz Ravenwood
> Database Developer / Programmer
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar