Can you give me a time index where I mentioned that? It's been a few years. :)

X23, Lesson 2, 30 second duration between 2:30 minutes and3 minutes.  It starts with: "Now, unfortunately...."  Ends with "We will cover that when we get into the advanced classes."
Because of COVID-19, most of our workers are teleworking still with a horribly-slow (Gov't) VPN of about 333 Kb/sec (not KB/sec), we have been trying to do all of our record keeping in a Cloud version of Excel via SharePoint.  Now that 25% of us are in the office, we want to revive our dB, but we have staff and bosses wanting to edit records in the office while letting remote workers do the same.  We should not have two sources of input.  X23's append new records is not adequate.  I need a way to keep using Update Queries with Cloud without overwriting newer office records and vice versa. If a date gets added by a boss in-house or remote, then the new value in that cell should overwrite the null so the bigger boss can fill the next field. X23 was a good start, but I need the "programming" X23 sequel. Please

Hi, Richard.  Did you find the programming part to extend X23?  Please.

Not yet. I'll look into it as soon as I can. That lesson is several years old, so I have to review it first to remember exactly what I was talking about.

Ok. Took me a bit to find it. That's lesson 1, not 2. I think you might find this helpful: Sync Remote Database

I'm also working on a seminar RIGHT NOW that shows you how to set up an inexpensive SQL Server online and you can use that for your data. So you still keep your Access front-end, split the database, and move the data up to the server. Then you just give the front-end to whomever needs it. Look for that by the end of the week.

Woohoo, I'm having withdrawal symptoms...can't wait to see it!

Thank you, Richard.  I am looking forward to that seminar.  We have a bunch of folks still on telework but we few that are back in the office are tired of putting stuff in a web-based Excel file with bunches of tabs (tables) that are occasionally transferred to temporary tables that are used for Update Queries.  We were only able to develop the COVID work-around because of lessons on Update queries that I got from you, Richard.