Identifying a Security Flaw with Linked Tables in a Microsoft Access Database, Part 2

preview_player
Показать описание
In this Microsoft Access tutorial, I will show you how to identify a significant security flaw involving linked tables and how to fix it using unbound forms and connection strings. This video covers setting up a connection string, opening record sets programmatically, and minimizing security risks in your Access databases. This is part 2.

Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will learn how to handle continuous forms and open arguments. I will show you how to adapt the technique to work with continuous forms and how to use open arguments to open forms for specific records.

MEMBERS-ONLY EXTENDED CUT VIDEO:

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

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,, security flaw, linked tables, split database, securing data, database password, front end, back end, connection string, unbound forms, VBA code, record set, ACCDE file, form load, form unload, record source, SQL Server backend, database security, user and group security, system log, workflow setup

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Рекомендации по теме
Комментарии
Автор

9 years back I benefit your videos so much
Appreciate all your efforts
Seeing you keep adding video means people are still using MS Access
I assumed its not being used any more
Not sure who would be using it now while everything is running on web based applications

MM-vgbm
Автор

Thanks Richard (and Juan) for the video!

Shadow.Dragon
Автор

Great Video. I think I'm gonna use it.

erniehaverhals
Автор

Interesting. Is there a way to do it for a form that uses a pass through query (which also uses connection string) as record source?

kkaminski
Автор

Great job, thanks. But what about the queries, and how we deal with them?

hassanrozh
Автор

I wish you would teach this topic completely and for free

shahramahmadzadeh