[AccessD] corrupt file error

rockysmolin bchacc.com rockysmolin at bchacc.com
Mon Nov 18 23:57:52 CST 2019


I sent her the stuff I gleaned from what you all wrote in your thread about this.  I did get an email from her a little later saying " The tech is taking a second try to fix it".  Haven't heard anything since.  I'll call her tomorrow. 

One of the most interesting databases I ever created.  Do you know how many different kinds of communion wafers there are? They service about 120 parishes who have standing weekly orders with extras for Lent, Easter, Christmas, and Advent. Shipping and billing. A little business they're running.  In a cloistered monastery in the middle of San Diego. 

r

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow via AccessD
Sent: Monday, November 18, 2019 7:42 PM
To: Access Developers discussion and problem solving
Cc: John Bartow
Subject: Re: [AccessD] corrupt file error

It's all over the web. Have the sisters send him a link.

John Bartow
WinHaven Consulting

-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of rockysmolin bchacc.com
Sent: Monday, November 18, 2019 7:26 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] corrupt file error



From: rockysmolin bchacc.com
Sent: Monday, November 18, 2019 5:01 PM
To: accessd at databaseadvisors.com
Subject: FW: corrupt file error

Tech support - can't live with 'em, can't kill 'em.

Sister Ara Marie (for whom I wrote an Altar Bread Distribution System years ago - but that's a long story) has the Runtime error '3340' Query 'qryUpdateShipDate is corrupt problem from an update query that was in a thread - last week? I posted Gustav's explanation to her and told her to ask their tech support to fix it - they would know what do to when they read the email.

(Sigh)

Rocky


From: Sr Ara Marie Young [mailto:sramycarmel at outlook.com]
Sent: Monday, November 18, 2019 4:11 PM
To: rockysmolin bchacc.com
Subject: RE: corrupt file error

Please can you fix it Rocky as it is in CABS the Tech wrote below that all was secure I guess he could not fix it?


Our Tech wrote "I ran an update and checked the security installer that file you got an email for is not affecting your computer.  your system is up to date and secure.

Thank you
David

Dear Carmelite Friends,

Our Email Provider has changed so please update your address book with this new email address sramycarmel at outlook.com Thank you.


Many of God's blessings,

Sister Ara Marie, OCD


Carmelite Monastery
Altar Bread Dept.
5158 Hawley Blvd.
San Diego, CA  92116
Email: sramycarmel at outlook.com
Phone:  (619) 280-5424 Ext. 161
Fax:      (619) 283-2121
Emergency: Cell#: (619) 971-0322 - Active during power outages Pickup Available: M,W,Th, F & Sat (8:00am to 2:45pm) Closed Tuesdays

I give you a new commandment love one another.  As I have loved you, so you also should love one another.   John 13:34


From: rockysmolin bchacc.com <rockysmolin at bchacc.com>
Sent: November 18, 2019 3:35 PM
To: Sr Ara Marie Young <sramycarmel at outlook.com>
Subject: RE: corrupt file error

Sister Ara:

Microsoft done busted your system.  You probably have automatic updates set on your system.  So when Microsoft has an update to Windows of Office, it happens automatically.

This is the update that happened a week ago:

https://support.microsoft.com/en-us/help/4484119/security-update-for-office-2013-november-12-2019

And here is the explanation:


> This is not a Windows update problem, but a problem that was 
> introduced with the November Patch Tuesday Office release.  A change 
> to fix a security vulnerability causes some legitimate queries to be reported as corrupt.
> Because the change was a security fix, it impacts ALL builds of 
> Office, including 2010, 2013, 2016, 2019, and O365.
>
> The bug has been fixed in all channels, but the timing of delivery 
> will depend on what channel you are on.
>
> For 2010, 2013, and 2016 MSI, and 2019 Volume License  builds, and the
> O365 Semi-annual channel, the fix will be in the December Patch 
> Tuesday build, Dec 10.
> For O365, Monthly Channel, and Insiders, this will be fixed when the 
> October fork is released, currently planned for Nov 24.
>
> For the Semi-Annual channel, the bug was introduced in 11328.20468, 
> which was released Nov 12, but doesn't roll out to everyone all at once.
> If you can, you might want to hold off on updating until Dec 10.
>
> The issue occurs for update queries against a single table with a 
> criteria specified (so other types of queries shouldn't be impacted, 
> nor any query that updates all rows of a table, nor a query that 
> updates the result set of another query).
> Given that, the simplest workaround in most cases is to change the
>
If you have some tech support for your system, show them this email and they will know what to do.

Otherwise, give me a call and we'll see if we can figure a way around this problem.

Best,

Rocky


From: Sr Ara Marie Young [mailto:sramycarmel at outlook.com]
Sent: Monday, November 18, 2019 1:07 PM
To: rockysmolin bchacc.com
Subject: corrupt file error

Good afternoon Rocky, I hope all is going well with you.  I received a error message Runtime error '3340' Query 'qryUpdateShipDate is corrupt, the message says.  It occurred when I was trying post a record O'Connors T069 ship week R with todays date.

Is it possible to fix this today? I thank you for your service and assistance!
Thanks a million Sr. Ara


Dear Carmelite Friends,

Our Email Provider has changed so please update your address book with this new email address sramycarmel at outlook.com Thank you.


Many of God's blessings,

Sister Ara Marie, OCD


Carmelite Monastery
Altar Bread Dept.
5158 Hawley Blvd.
San Diego, CA  92116
Email: sramycarmel at outlook.com
Phone:  (619) 280-5424 Ext. 161
Fax:      (619) 283-2121
Emergency: Cell#: (619) 971-0322 - Active during power outages Pickup Available: M,W,Th, F & Sat (8:00am to 2:45pm) Closed Tuesdays

I give you a new commandment love one another.  As I have loved you, so you also should love one another.   John 13:34



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

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



More information about the AccessD mailing list