[AccessD] Uninstalling Office Update

[Daniel Waters]

Hi David,

I'm going to guess that you would use the '16.0.' in code meaning Office 16 (or Office 2016).  The last 3 numbers look like a transposing issue - it's either 20262 or 20226 - one of them is correct.  I would try the 20226 just because that's what you found on a website describing the fix.

Hope this helps!
Dan

-----Original Message-----
From: AccessD <accessd-bounces+df.waters=outlook.com at databaseadvisors.com> On Behalf Of David Emerson
Sent: 12 January, 2023 15:41
To: AccessD <accessd at databaseadvisors.com>
Subject: [AccessD] Uninstalling Office Update

Hi Listers,

The latest version of Office 365 has recently been installed on my machine (Version 2212 (Build 15928.20216 Click-to-run).

Since then I have started getting errors when I link to SQL tables without using a DSN (basAttachDSNLessTable).  The error is 3125 - "dbo.tblGroup is not a valid name. Make sure it is a valid parameter or alias name, that it does not include invalid characters or punctuation, and that the name is not too long".  I get a similar error for several different databases doing the same thing.

I am wanting to revert back to a previous build of Office to see if this is the problem but am having trouble finding out how to.  I think the one I want is Version 2212 (Build 15928.20198) from Jan 4.

One website suggested this:

To rollback Office to one specific version, you could also try to run following command.
Such as "C:\Program Files\Common Files\microsoft shared\ClickToRun\officec2rclient.exe" /update user
updatetoversion=16.0.14701.20226

This was from Dec 2021.  But according to this page
(https://learn.microsoft.com/en-us/officeupdates/update-history-microsoft365
-apps-by-date) the version numbers around that time were Version 2111 (Build 14701.20262).  So I am not sure how that translates to something like
16.0.14701.20226

Any pointers?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand



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