Rabu, 18 April 2012

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

 

I don't know Bill. I know that we have to go through Citrix to open up Access and it's on a box that I thought we all shared. I believe we have a site license or something to run multiple copies.

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 3:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.

Liz

You never install Access on a server. What are you talking about?

Bill

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> I guess not. This is bad. Corporate IT doesn't support Access officially. If I have to have an install to the app servers, that'll not be so good...
>
> 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:24 PM
> To: 'MS_Access_Professionals@yahoogroups.com'
> Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
>
> Hey Bill Thanks.
>
> So it will work for 2007 too?
>
> 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:17 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
>
> Liz - maybe this hotfix will fix it.
> http://support.microsoft.com/kb/2596585
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@> wrote:
> >
> > 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.
>
>
>
> ------------------------------------
>
> 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