Senin, 23 April 2012

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

 

Liz

I found this thread that might help your IT dept. sort out this corruption (if that's what it is)
http://answers.microsoft.com/en-us/office/forum/office_2007-access/microsoft-office-has-detected-that-this-database/3fb41c70-f7ba-41dd-a847-e62203071466

Take a look ath the reply by Francis Claessens. He talks about having problems with databases on Citrix.

Bill

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> ... and that one module not working story was on an entirely different database
>
> 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: Thursday, April 19, 2012 8:21 AM
> To: 'MS_Access_Professionals@yahoogroups.com'
> Cc: Bruce Patterson
> Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
>
> True. There isn't any documentation out there, and I don't know if my boss would want to pay for the support. It's a few hundred dollars just for the phone call.
>
> I've seen something similar where one module didn't work. I could even watch it in debug say that it was doing the right thing, but it was not. I put a little text box on the main form so that I could see values set even outside of the debugger as real time. It said it was doing it, it was not.
>
> The thing that did work for that database was the rebuild from scratch and import all the objects. Remembering that experience made me optimistic that that step would work for this one, but it didn't. It doesn't perform any of the code on any of the command buttons. The user clicks and ... nothing ... unless they run the accdb.
>
> WEIRD.
>
>
> 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: Thursday, April 19, 2012 7:23 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
>
> So the accdb works and the accde doesn't work? That's just plain weird. Sorry, but I don't have a clue as to why that would happen.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@> wrote:
> >
> > So what I did was moved the unsecure accdb copy out for the users to use. Completely unsecure, but wtf I can't afford to waste any more time and I can't afford to not have their code working for them. I have a lot of automation built in and won't lose it.
> >
> > 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.
> >
>
>
>
>
> ------------------------------------
>
> 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