Uploaded August 2026 | Updated September 2026, 2 weeks ago
In today's Quick Queries we will discuss when an Access application should be extended rather than rebuilt as a web app, including split databases, SQL Server backends, remote desktop, and focused web or mobile access. We will also cover the VBA Date and Now difference, refreshing a sandbox database from production data, troubleshooting corruption after power loss, and safer ways to delete records from an open Access form.
Arthur from Houston, Texas (a Gold Member) asks We've used our Access database for about 10 years, and it still works well for everyone in the office. We may be hiring a couple of remote employees who need some of the same data. I keep seeing ads saying we should replace Access with a modern web app. Do we really have to rebuild everything?
CHAPTERS:
00:00 Introduction
01:17 Do You Need To Replace Access With A Web App?
17:25 Recommended Access And SQL Server Training
18:06 Why Date And Now Behave Differently In VBA
21:35 Refreshing A Sandbox Database From Production
24:51 Recovering From Power Outages And Database Corruption
29:06 Format Painter Tip
29:35 Video Quiz Feedback
34:33 AI Thumbnail Feedback
38:16 Deleting Records From An Open Form Recordset
44:23 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Quick Queries #105: 599cd.com/QQ105
LINKS:
Split Your Database: 599cd.com/Split
Connect Access: 599cd.com/ConnectAccess
Online Database: 599cd.com/OnlineDatabase
Access on a Phone: 599cd.com/AccessOnAPhone
Power Apps: 599cd.com/PowerApps
Specs & Limits: 599cd.com/SpecsLimits
File Sharing: 599cd.com/FileSharing
Security Flaw: 599cd.com/SecurityFlaw
Periodically Sync: 599cd.com/a?127304
Sync Remote Database: 599cd.com/SyncRemoteDB
Access Web Sync Seminar: 599cd.com/MFVAK
Corruption From Power Outage: 599cd.com/a?126845
Troubleshooter: 599cd.com/Trouble
Recordsets: 599cd.com/Recordset
CyberPower ST425: amzn.to/3Ukh60l
CyberPower CP1500: amzn.to/4zpDYMe
UP NEXT:
Quick Queries #106: 599cd.com/QQ106
Captain's Log: 599cd.com/Log
Merch Store: 599cd.com/Merch
RECOMMENDED COURSES:
SQL Server for Access Users: 599cd.com/SQLSA
Access SQL Server Online: 599cd.com/SQLOnline
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, QQ, Quick Queries, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, replace Access with web app, Access SQL Server migration, remote Access users, Access frontend with SQL Server, Access over internet, Access mobile access, split database, ACCDB 2GB limit, Date vs Now VBA, Access database corruption, Recordset.Delete continuous form
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In today's Quick Queries we will discuss when an Access application should be extended rather than rebuilt as a web app, including split databases, SQL Server backends, remote desktop, and focused web or mobile access. We will also cover the VBA Date and Now difference, refreshing a sandbox database from production data, troubleshooting corruption after power loss, and safer ways to delete records from an open Access form.
Arthur from Houston, Texas (a Gold Member) asks We've used our Access database for about 10 years, and it still works well for everyone in the office. We may be hiring a couple of remote employees who need some of the same data. I keep seeing ads saying we should replace Access with a modern web app. Do we really have to rebuild everything?
CHAPTERS:
00:00 Introduction
01:17 Do You Need To Replace Access With A Web App?
17:25 Recommended Access And SQL Server Training
18:06 Why Date And Now Behave Differently In VBA
21:35 Refreshing A Sandbox Database From Production
24:51 Recovering From Power Outages And Database Corruption
29:06 Format Painter Tip
29:35 Video Quiz Feedback
34:33 AI Thumbnail Feedback
38:16 Deleting Records From An Open Form Recordset
44:23 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Quick Queries #105: 599cd.com/QQ105
LINKS:
Split Your Database: 599cd.com/Split
Connect Access: 599cd.com/ConnectAccess
Online Database: 599cd.com/OnlineDatabase
Access on a Phone: 599cd.com/AccessOnAPhone
Power Apps: 599cd.com/PowerApps
Specs & Limits: 599cd.com/SpecsLimits
File Sharing: 599cd.com/FileSharing
Security Flaw: 599cd.com/SecurityFlaw
Periodically Sync: 599cd.com/a?127304
Sync Remote Database: 599cd.com/SyncRemoteDB
Access Web Sync Seminar: 599cd.com/MFVAK
Corruption From Power Outage: 599cd.com/a?126845
Troubleshooter: 599cd.com/Trouble
Recordsets: 599cd.com/Recordset
CyberPower ST425: amzn.to/3Ukh60l
CyberPower CP1500: amzn.to/4zpDYMe
UP NEXT:
Quick Queries #106: 599cd.com/QQ106
Captain's Log: 599cd.com/Log
Merch Store: 599cd.com/Merch
RECOMMENDED COURSES:
SQL Server for Access Users: 599cd.com/SQLSA
Access SQL Server Online: 599cd.com/SQLOnline
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, QQ, Quick Queries, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, replace Access with web app, Access SQL Server migration, remote Access users, Access frontend with SQL Server, Access over internet, Access mobile access, split database, ACCDB 2GB limit, Date vs Now VBA, Access database corruption, Recordset.Delete continuous form
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
