Microsoft Access Quick Queries #22: Performance over VPN, Fixing Grainy Logo, Record Locking, More!

In this Microsoft Access tutorial, I will guide you through practical solutions to common issues, including setting focus on fields, handling slow performance over VPNs, and adjusting date formats. We'll also explore image transparency challenges in reports and maximizing database efficiency with calculated fields. Dive into these essential tips for enhancing your Access experience.

TOPICS
- Access database performance over VPN
- File-based vs. client-server databases
- Access front-end with SQL Server backend
- Slow Access database with file-sharing services
- Fixing grainy logo in Access reports
- Calculating expiration dates with DateAdd
- Windows ISO date format vs. Access formats
- Access transparency issues with GIF/PNG images
- Installing Access on Windows S mode
- Using Access over a local vs. wireless network
- Record locking in Access databases
- Locking fields in Access with VBA
- Get next-to-last record using DMax
- Access Developer Network for custom solutions
- Why fields don't have spaces (naming conventions)
- Tracking changes with a change log table
- Automatically deleting old log records
- Date formatting: extracting year from datetime
- Adding combo boxes in Access search forms
- Breadth-first vs. depth-first learning
- Handling prerequisites in tutorial videos

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

UP NEXT:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, SetFocus, Column Heads, Linux, Invert Boolean, VPN Access, file-based database, Access frontend, SQL Server backend, DateAdd function, ISO date format, SharePoint Access, field locking VBA, DMax function, Access combobox parameters, date-time conversion, combo box filtering, auto number limitation.

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[Shadow.Dragon]

Richard, I always look forward to your Quick Queries! They are great reminders of the Legos we have to work with!

[tomscroggin]

Thanks Richard for another great video. After 20 years of Access, I'm still learning. Without your videos, I'd be lost and would have given up many years ago.

[runmeramen]

YOUR videos are very helpful, thank you!

[zmareyshahi]

I may miss some videos but not access queries series and sometimes I do get back to those videos after seeing queries about it in this series

[thetruesimplegrid]

Your content has really helped me with my course projects.

I’ve just got one question, how can I copy a field from my query into a table?

[gregoryjeffries]

Found something today. For button controls, "On Exit" event. Good for use on main menu exit, close or quit.