__________________ Bob Fitzpatrick Microsoft Community Contributor Award (2011) If this helped, please click the scales at the bottom left of this posting. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. Many thanks.
I have never failed. I have found a thousand ways that do not work!
First of all I would like to say that unfortunately in these cases we rely on Microsoft itself which is really indifferent to whatever problems it may cause to any users who have an Access application either in their business or even for personal use. Personally, till now i didn't yet seen any official apology from Microsoft for this problem which seems to affect almost everyone since a professional application is almost certain to include at least one update query.
I am going to talk about us which we are a small developer company (4 developers) and we have already created dozens of applications with Ms Access that have been sold to several of customers and already we are constantly receiving complaints about this problem from almost everyone. Microsoft announces that it will fix the problem in a future update (December 10th) and is indifferent that we need to find an immediate solution for all customers facing this problem now, not on December 10th.!!!! Until then, all developers are urged to spend tens of hours eachone in order to makes the urgent modification which microsoft proposes to those who can't wait for the new update in almost 1 month (!!) from now.
For those of you who are interested in the solution which Microsoft suggests, i will let you know that already it has been tested by us and indeed the problem is solved as following below
I've just added instructions on how to remove the Nov update if you have Office 365
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.
Colin (Mendip Data Systems) To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Website links: To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
I had the issue. and was able to restore O365 to the previous version, until its safe to resume automatic updates. There was a worse problem last year.
I thought my users also had a problem writing data directly to a table opened in a recordset, as well as the single table queries failing.
MS "solution" seemed just totally impractical. Check and re-write every append query (maybe update query as well)? Really?
Anyway for O365, I used a variation of this solution, as there is no uninstall option for click to run access.
I added what I thought was another note to this thread, but it actually posted in another thread. Anyway A2003 is not affected by this, if anyone is still using old time access.
__________________
Dave (Male!)
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
Last edited by gemma-the-husky; 11-20-2019 at 05:09 AM.
Linear Mode
