UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Microsoft Access Help Forums
The premier Microsoft Access help forum with Visual Basic, SQL Server, Office and more! Members are able to post questions and help others with problem solutions. UtterAccess has been seen in over 160 countries, recording over one billion hits to date. Microsoft Access Tables, Queries, Forms, Reports, Pages, Macros, Modules...you'll find all the free samples and answers here!

Registered members have access to all the file attachments that UA is pleased to provide. An added bonus along with many other features such as Access sample databases, professional Access code samples, file uploading, private messaging and forum subscriptions...all this for those who take a moment to sign up...(Your personal information is kept completely confidential and everything is truly free of charge!)

Over 250,000 members have signed up at UA to enjoy well over 2,500,000 posts - proving UtterAccess.com is the only source for help with Microsoft Access...and more!
> Additional UA Navigation
Discussion ForumsCode Archive Table of ContentsThe Microsoft Access WikiNewcomer's Reading List
Today's Active TopicsHow to post a good questionContact UADifferences in Access Versions
> Office Update Can Cause Issues With Access Queries
Posted by DougY - Nov-13-19 - 25 replies
The November Patch Tuesday Office release introduce an issue with Access queries. A change to fix a security vulnerability causes some legitimate queries to be reported as corrupt. The update is 1328.20468; it was released Nov 12, but hasn’t rolled out to everyone all at once.

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.

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

Information and workaround can be found here: Access error: "Query is corrupt"
Read 2081 times - Reply   print fwd
> Jack, The Magic Beans, And 10k Posts
Posted by DougY - Sep-19-19 - 9 replies
He thought we forgot...maybe we did, maybe we didn't, he can't prove it evilgrin.gif

Now that our vague admission is out of the way:

Jack (jleach) has reached and passed the 10K post milestone. For the years he's been here, Jack provided solid advice, and knowledge to our members. (rumors are he even racked enough UA catalog points to qualify for the collapsible travel fishing rode ohyeah.gif )

Thanks for what you do. Keep up the good work cheers.gif
Read 4751 times - Reply   print fwd
> Thousands For RJD (ten of them!)
Posted by jleach - Sep-15-19 - 20 replies
Please join me in congratulating Joe (RJD) in reaching an impressive 10000 post milestone.

More impressive than the quantity of the posts though is the quality. The advice he gives UA members is always solid, this manner polite and thoughtful, and his willingness to grab a copy of someone's Access file to dive in and help sort things out is unparalleled.

All in all, he is a rare type of contributor where those he helps can be sure they're being well guided, every time.

Thank you, Joe, for being a great help to our members and community. hat_tip.gif
Read 3460 times - Reply   print fwd
> Recommended sites and books
SitesBooks
Access Team BlogMicrosoft Access Small Business Solutions
Access Dev CenterProfessional Access 2013 Programming
Access 2013 Inside Out
> Online
1426 users active in the past 60 minutes
Active Users1415 guests, 11 members
admantx.com, ahrefs.com, bing.com, brandwatch.net, cheekybuddha, drakopp, facebook.com, Google.com, grapeshot.co.uk, isladogs, ixxo09, jleach, June7, lddt, ngins, nvogel, ollyhutsy, PaulBrand, proximic.com, yandex.com
Custom Search


RSSSearch   Top   Lo-Fi    21st November 2019 - 04:07 AM