Re: 2003 Repair / Compact Problem

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

  • Re: 2003 Repair / Compact Problem
    ... I am running A2002/A2003 and A2007 on Vista and have ... 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: 2003 Repair / Compact Problem
    ... I am running A2002/A2003 and A2007 on Vista and have ... 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: 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)
  • Re: 2003 Repair / Compact Problem
    ... My shortcuts are ... "Run as Administrator". ... Currently I have Windows Vista UAC turned off, therefore not sure, without ... although frequently that also gets an Unresponsive error as well. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: 2003 Repair / Compact Problem
    ... 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