Rabu, 18 April 2012

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

 

... "has started complaining..."

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Wednesday, April 18, 2012 1:12 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.

Hi Bill, It's good to hear from you.

It's in a folder that has been working and where I run all 33 databases and nobody has quit complaining. Just to rule that out, I did compile to my own area and tried to run it to no avail.

I have:
1. compact and repair
2. decompiled
3. created a whole new db and imported all the objects, compiled to same area, and tried to run

The accde will not perform the vba that is in the accdb.

At the end of the day, if I can't get this to work, I'll send up an unsecured accdb file for the users to use. I can't have people not getting their work done.

Here's some irony: I googled this, and about 8 different links sent IE in to a "Internet Explorer is not responding..." message and I had to shut the tab.

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Wednesday, April 18, 2012 1:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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.
>

------------------------------------

Yahoo! Groups Links

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.

------------------------------------

Yahoo! Groups Links

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