[AccessD] Access 2007 - The story so far.

Darryl, I want to go to one of your earlier characterizations of the
problem:

Quoting:
...the script used to update the database on the other PC's was failing
[when]
the front end tried to talk to the back end using ADO.  If I manually ran it
then Access seemed to fix the reference, but using script to open the accde
file it would always fail as per the links below.

1) What do you mean "update" the database on the other machines?... you mean
anything at all (insert, delete, etc) or do you mean copying objects?
2) What do you mean when you manually ran it? Ran what, the script? 

Can you give more details of when this does and does not fail?

Does it fail in either of these environments

If a database and excel file which uses ADO to query the accdb file are both
on a W7SP1 user's machine then given to a client such that
    a) XP user keeps both files on his/her desktop
    b) Several XP users keeps the Excel file on their PCs and the accdb on
goes on a server for 
          several users to make use of

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, August 22, 2011 12:29 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 - The story so far.

The KB which you you can't find is quite short.  Here it is:

How to uninstall Windows 7 Service Pack 1 (SP1)

Windows 7 Service Pack 1 (SP1) contains many updates to improve Windows 7,
but if you 
encounter a problem with hardware or a program after installing the service
pack, you might 
want to temporarily uninstall it to troubleshoot the problem.


If you installed SP1 yourself, you can uninstall it. However, if your
computer came with SP1 
already installed, it can't be uninstalled.



Uninstalling SP1 using Programs and Features

The easiest way to uninstall SP1 is using Programs and Features.

    Click the Start button Picture of the Start button, click Control Panel,
click Programs, and 
then click Programs and Features.

    Click View installed updates.

    Click Service Pack for Microsoft Windows (KB 976932), and then click
Uninstall.

    If you don't see Service Pack for Microsoft Windows (KB 976932) in the
list of installed 
updates, your computer likely came with SP1 already installed, and you can't
uninstall the 
service pack. If the service pack is listed but grayed out, you can't
uninstall the service pack.

Uninstalling SP1 using the Command Prompt

    Click the Start button Picture of the Start button, and then, in the
search box, type 
Command Prompt.

    In the list of results, right-click Command Prompt, and then click Run
as administrator. 
Administrator permission required If you're prompted for an administrator
password or 
confirmation, type the password or provide confirmation.

    Type the following: wusa.exe /uninstall /kb:976932

    Press the Enter key.

If you can't uninstall SP1

If you've used Disk Cleanup since installing SP1, the backup files needed to
uninstall the 
service pack might have been deleted from your computer. To remove the
service pack, 
you'll need to reinstall Windows 7. For installation information, see
Installing and reinstalling 
Windows 7.


On 21 Aug 2011 at 23:54, Arthur Fuller wrote:

> I guess I'm screwed. I can't find that KB. Does 2010 have these
> problems as well? Shit shit shit.
> 
> A.
> 
> On Sun, Aug 21, 2011 at 10:53 PM, Darryl Collins <
> darryl at whittleconsulting.com.au> wrote:
> 
> > Hi Arthur,
> >
> > This is what I did.  It worked fine, but it took bloody ages, I
> > suggest you do it late in the day and let the machine reboot it self
> > overnite - seriously it took about 3 hours all up.
> >
> > << http://windows.microsoft.com/uninstallwindows7sp1>>
> >


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com