[AccessD] corrupt file error

[Daniel Waters]

Perhaps they all worked together!  Good to have friends like that!  :-)

Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: November 20, 2019 15:45
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] corrupt file error

Excellent. 

If prayer can't help at least it wouldn't hurt. :-)

Jim

----- Original Message -----
From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Cc: "John R Bartow" <jbartow at winhaven.net>
Sent: Tuesday, November 19, 2019 8:44:31 PM
Subject: Re: [AccessD] corrupt file error

Never disregard any blessings! 😊

When I got Bell's Palsey earlier this summer the neurologist (Dr. Glassisempty) said I had "no hope of recovery  - except maybe prayer, if you're one of that type." 

Besides him doing zero for the money I paid him, that comment irritated me.

So, I sent an email out to all of the various religious organizations I have done work for over the years. I figure that pretty much ran the gamut of known religions. Within a couple of days my excruciating pain was gone. Not sure which group pulled it off but that was the best quid pro quo I know of!

Then I set out to prove the glass was half... 😉

-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of rockysmolin bchacc.com
Sent: Tuesday, November 19, 2019 8:47 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] corrupt file error

As I understand it, there are two main bakeries in the U.S. - one on the East coast somewhere and one in St. Louis.  They order in bulk from St. Louis. Whole wheat and white.  Communicant's wafers (5 inch), sick people wafers - small ones.

Being Jewish it was all new to me. :)

She belongs to the Discalced order of Carmelites - they go either barefoot or with sandals. 

The first sister I worked with there was a propeller head like me - had done the first system in Dbase.  But she needed more and so I got hired.  That was almost 19 years ago.  I still do a little work for them - 3-4 times a year I'll hear from Sister Ara with a question or a need for something.

Recently they went to O365 and that's where I think the problem is that she's having - that update query thing. 

Anyway, she's always blessing me and that can't hurt a bit (seems to be working actually). 

r

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

I had no idea. I know some parishes make their own but I always figured was more of a participation effort than anything else. Do they make wine too?

John Bartow
WinHaven Consulting

-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of rockysmolin bchacc.com
Sent: Monday, November 18, 2019 11:58 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] corrupt file error

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

--
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

--
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

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