Oh, Citrix! That's a horse of a different color. Yes, you would have Access installed on th eserver in that case.
Did you check the trusted locations? I think I've asked about 3 times now. :)
Bill
--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> 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.
>
Tidak ada komentar:
Posting Komentar