Access bug on Update queries (1 Viewer)

The_Doc_Man

Happy Retired Curmudgeon
Joined
Feb 28, 2001
Messages
15,698
Oddly enough, I wonder if this bug is related to something else that has sometimes shown up in this forum, and that in fact happened to me once.

The workaround for the bug is to make a single-table query that takes in the whole table (i.e. SELECT * FROM table), then work through that rather than directly updating the table. When I was building some forms bound to back-end tables, I would get a dialog box asking where Access could find the tables even though I had used Linked Table Manager to build the linkages. But when I created the single-table queries and bound the forms to the queries, it went silent and never again asked me where to find the record sources.
 

gstylianou

Registered User
Joined
Dec 16, 2013
Messages
224
Hey, DO NOT make anything..!!!

After the last window 10 update, something happened to ms office 2016 pack. The only way to fix the problem is to uninstall and re-install the office pack..
 

theDBguy

I’m here to help
Joined
Oct 29, 2018
Messages
7,845
Hey, DO NOT make anything..!!!

After the last window 10 update, something happened to ms office 2016 pack. The only way to fix the problem is to uninstall and re-install the office pack..
Hi. When you said "something happened" to Office and have to fix it, what "problem" are you fixing? What bad behavior, other than the one we were already discussing here, were you observing? Just curious...
 

vba_php

Custom Title Here
Joined
Oct 6, 2019
Messages
2,081
FYI to all - everyone and their dog knows about this. An article on this bug even came through google's news feed about this the other day!
 

Lightwave

Ad astra
Joined
Sep 27, 2004
Messages
1,432
Just tried it in MS Access 2003 and it seems to work. Seriously for me Access 2003 refuses to break - I can still connect to Azure with it.???

In some ways maybe this is a good thing maybe they will test better before release especially for MS Access.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom