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
> New UtterAccess Moderator
Posted by DougY - Nov-26-19 - 16 replies
We are pleased to announce that UtterAccess VIP cheekybuddha has been appointed as an UtterAccess Moderator.
cheekybuddha joined UA in December 2003 and since than he has helped countless members.

Congratulations, cheekybuddha, welcome to the engine room cheers.gif
Read 735 times - Reply   print fwd
> Office Update Can Cause Issues With Access Queries
Posted by DougY - Nov-13-19 - 39 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 4344 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 5487 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
664 users active in the past 60 minutes
Active Users657 guests, 7 members
Aakburns, ahrefs.com, bing.com, brandwatch.net, drakopp, Gero, Google.com, grapeshot.co.uk, June7, nvogel, proximic.com, rubio19703, Vince, yandex.com
Custom Search


RSSSearch   Top   Lo-Fi    9th December 2019 - 02:23 AM