Access - VBA Routine con Timer

05^ Lesson In development mode it is necessary to have exclusive access and in any case sometimes it is necessary not to have users connected in it because we have to perform delicate operations. So in this lesson we will understand how to manage users who access the database, through a flag placed in a table we will be able to decide whether users will be able to access the database or not. =========== INVEST IN YOUR TRAINING ================== Are you looking to improve your skills and obtain a digital certificate of attendance? My Masterclasses offer exclusive content and a complete learning experience. By purchasing from my site you will also have access to exclusive discounts. Don't miss the opportunity to grow professionally. https://www.bi4you.it/masterclass/ =========== SUBSCRIBE ON YT ================= Subscribe to this channel to access the benefits:    / @lodovicodincau   ======= SAFE AND AFFORDABLE SOFTWARE! == Office, Windows, Antivirus, VPN, Server: https://mrkeyshop.com/it/?MrKey=484 ======= MY EQUIPMENT =============== Mouse: https://amzn.to/3s1XwF2 Yeti microphone: https://amzn.to/3MDCggU Microphone without stand: https://amzn.to/3LAoWcS Yeti filter: https://amzn.to/3KwKAO2 Sony Alpha 6400L: https://amzn.to/3t5cN8u Elgato Stream Deck: https://amzn.to/3NDf0RM Elgato Cam Link 4K: https://amzn.to/3NHXtIb Elgato Facecam: https://amzn.to/3F1Cagk TC Helicon Mixer: https://amzn.to/3TbTmoZ RGB keyboard: https://amzn.to/3MGytiL 2k Gaming monitors: https://amzn.to/3vYb7OP Switch: https://amzn.to/372aYl8 Microsoft 365 Family: https://amzn.to/38H85qc Microsoft 365 Business: https://amzn.to/3OSDQO2 My name is Excel - troubleshooting: https://amzn.to/3vVBPb1 The Definitive Guide to DAX: https://amzn.to/376c7s2 Prime Student 90 days free: https://amzn.to/3MJ8LKw ============ R I S O R S E ==================== Channel index - Available to subscribers only: https://docs.google.com/spreadsheets/... DOWNLOAD subscribers: https://drive.google.com/file/d/14ez_... Lesson Chapters: 00:00 Introduction 02:03 Creation tb Maintenance 03:46 "Event" properties window 05:13 Event "On Timer" - "Interval Timer" 07:33 Location of routines in objects 08:29 Logic of routine 09:42 Database // Libraries initialization 12:18 Recordset initialization 13:51 db.OpenRecordset 15:32 Query 1: Extract maintenance status 19:07 Query 2: Extraction of administrator user status 19:49 Query 2: Where condition logic 20:29 Query 2: Environ("username") 22:14 Query 2: String written on multiple lines 23:25 Query 2: Where condition with parameter 26:43 How to test query text in vba 29:38 Brief summary 30:05 Reading the contents of the recordset rst.fields(0) 34:42 If to close database when in maintenance 36:01 Deactivating recordset and db 36:40 Installation on Order Search mask 38:14 Conclusions 39:08 Greetings #MSAccess #RoutineWithTimer #EventOnTimer #IntervalTimer