Re: 2003 Repair / Compact Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Bob, Bill,

Thanks for the additional feedback.

I wonder why it "appears" to have resolved my problem and not yours.

I managed to compact/repair and build an ADE without incident several times
after "Running as Administrator". I accept this is hardly extensive testing,
but it wasn't something I had been able to do with any consistancy before.
Although, I am curious as to why with the UAC turned off "Running as
Administrator" should have any impact.

The only other input I can provide, at this stage, is that I am running a
similar environment on Windows XP (ie. A2002/A2003 and A2007 + SQL Server
2000) and it all works as expected.

Oh well another idea shot down in flames. I'm sure it wont be the last :-)

Likewise will post any additional thoughts I have to this newsgroup.

Cheers
Guy


"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

  • Re: 2003 Repair / Compact Problem
    ... When "Running as Administrator" I as was able to compact/repair and make an ... ADE several times without incident, which I accept is not extensive testing, ... I am also curious as to why "Running a Administrator" should ... Still getting up to speed on Vista, but I'm sure there will plenty more ...
    (microsoft.public.access.adp.sqlserver)
  • 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: Vista "complaints"
    ... Recent misconceptions about Vista and UAC posted to the Focus-Apple group, ... administrator, and combined with the many configuration options Vista ... run an installation file need to do so in admin mode. ... that Win XP gave her the ability to add permissions to her normal ...
    (Focus-Microsoft)
  • 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: Installation problem - non-admin users
    ... I guess I am facing an administrative privileges issue with Vista. ... Log on as an administrator or contact your system administrator. ... The user is going to be asked to give a user-id and psw to an user/admin account. ... The user account for the non-user admin in not an account that has full rights on System32. ...
    (microsoft.public.windows.vista.security)