Re: 2003 Repair / Compact Problem

Guy, Bill,
Running as administrator did not fix my problem (also intermittent and it happens more than not )
My UAC was already turned off.
I will post any additional findings on this.
My problem is not an unresponsive one. I get

Microsoft Office Access Has Stopped Working
-Check online for a solution and close the program
-Close the program
-Debug the program

Thanks for the shared findings,
Bob.


"Guy" <Guy@xxxxxxxxxx> wrote in message news:OYHc8tmrHHA.4764@xxxxxxxxxxxxxxxxxxxxxxx
Bill, Bob,

I believe I have resolved the problem and that is that you do indeed need to "Run as Administrator".

Right mouse click your MS Access shortcut (or the executable) - "Run as Administrator", or to always "Run as Administrator" right mouse click/shortcut tab/advanced and check "Run as Administrator".

Currently I have Windows Vista UAC turned off, therefore not sure, without doing further research, as to why performing actions such as compact repair and make ade within Access cause an "Unresponsive error", although, I am confident that there is perfectly logical explanation. I would assume that if you have UAC turned on then you will be prompted for confirmation of those actions, and others considered a security threat, by the UAC (I haven't tried it).

Still getting up to speed on Vista, but I'm sure there will plenty more Vista learning expriences for developers to consider, not least of which will be the UAC.

I wonder if looping through the reports collection now works? Must try it.

Let me know if this solves your problem.
Guy



"Bill Patten" <bill_patten@xxxxxxxxxxxxxxxx> wrote in message news:1AED8559-E539-4BF4-981A-510A2FEC6217@xxxxxxxxxxxxxxxx
Well that was certainly easier than changing out my hard drives.

Bill
"Guy" <someone@xxxxxxxxxxxxx> wrote in message
news:eshMx$irHHA.4764@xxxxxxxxxxxxxxxxxxxxxxx
Bill wish I had a development environment like yours :-)

Can't really comment of potential driver issues other than I would expect
the O/S and other applications to experience problems as well.

Will try and find some time to investigate further.

Guy
"Bill Patten" <bill_patten@xxxxxxxxxxxxxxxx> wrote in message
news:83CF00F6-8947-44D8-8703-781B6B32C170@xxxxxxxxxxxxxxxx
Another thought just occurred to me, since we seem to be the only 3 people
in the world with the problem perhaps there is another explanation. Most
of
the error's occur when making ade/mde compact and repair all of which
create
temporary files. Could it be hard drive drivers? Any for comparison I am
running the following hardware
Dell XPS 410
2 250G SATA hard drives configured raid 0
Intel Raid controller
Intel Matrix storage console?
nVidia 8600 video card, but I had the problem with the nVidia 7300LE
E6600 duo core processor
and 4 G of ram.

Hope this creates a clue

Bill

"Guy" <Guy@xxxxxxxxxx> wrote in message
news:%23qxiFfhrHHA.4548@xxxxxxxxxxxxxxxxxxxxxxx
Hi Bob,

Just to confirm, I am running A2002/A2003 and A2007 on Vista and have
experienced the same problem, although, it is itermittent, but more
frequent
than not. Haven't tried XP, which I use as my SQL Server 2000 Server
platform, as according to MS, Vista doesn't fully support SQL Server 2000,
but will do, the symptoms are that an application gets an Unresponsive
error.

I am also experiencing more A2007 database corruptions than I would expect
which I ususually solve by Importing all the objects into a clean ADP,
although frequently that also gets an Unresponsive error as well.

Will investigate further if I have them time.

Comments/Thoughts anyone?

Cheers
Guy


"Bob" <bobmcc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6166447D-FFC1-48B1-8AAB-A7FF51A2ACC3@xxxxxxxxxxxxxxxx
> With 2007 & 2003 Co-Exiting on the same machine, I can no longer
> repair & compact my 2003 .adp files. I realize there are known issues
> with
> having both on the same machine but did not know about this one. Is
this
> a
> known problem or does anyone have a fix for it?
>
> Thanks in advance,
> bob mcclellan







.

Relevant Pages

  • Vista "complaints"
    ... Recent misconceptions about Vista and UAC posted to the Focus-Apple group, ... administrator, and combined with the many configuration options Vista ... that Win XP gave her the ability to add permissions to her normal ...
    (Focus-Microsoft)
  • Re: Run As Adminstrator - why hasnt it saved us?
    ... UAC and Run As Administrator are tied together on Vista and are the new security profile for the Admin and Standard user accounts. ... You set your account to be Super Admin so that you still have UAC enabled because some applications will not work correctly with UAC off, those applications using the Vista UAC manifest as an example, and by being Super Admin, UAC will not prompt you as Super Admin, as stated in the link. ...
    (microsoft.public.windows.vista.security)
  • Re: 2003 Repair / Compact Problem
    ... Administrator", or to always "Run as Administrator" right mouse ... Currently I have Windows Vista UAC turned off, therefore not sure, without ... which I ususually solve by Importing all the objects into a clean ADP, ... although frequently that also gets an Unresponsive error as well. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: UPNP Problem with Windows Vista (or maybe COM problem)
    ... No. UAC is especially significant when you are an admin. ... Right-click on your app and select "Run as Administrator" from the menu. ... My name is Ran and I am working on the windows CE group ... I was able to discover CE devices from my vista box and to also get the ...
    (microsoft.public.windowsce.platbuilder)
  • Re: 2003 Repair / Compact Problem
    ... Fault Module Name: StackHash_babb ... I believe I have resolved the problem and that is that you do indeed need to "Run as Administrator". ... Currently I have Windows Vista UAC turned off, therefore not sure, without doing further research, as to why performing actions such as compact repair and make ade within Access cause an "Unresponsive error", although, I am confident that there is perfectly logical explanation. ...
    (microsoft.public.access.adp.sqlserver)
Quantcast