Hello
I'm seeking advice on implementing best practices for preventing unauthorized access to a SQL Server database within Access applications. Here's the scenario:
Background:
We have an Access application that connects to a SQL Server database backend.
Users authenticate through the Access...
Hello
Check below steps, what you can do:
Check Trigger Code: Look at the code of your login trigger to make sure it's written correctly and isn't causing any errors.
Test Trigger: Turn off the login trigger temporarily to see if the logs start showing up again. This will help figure out if...
Hello
Troubleshoot VBA code not running after moving to a shared folder:
Check Permissions:
Ensure proper read and execute permissions for VBA code and files.
Macro Security:
Enable macros and adjust security settings in Excel.
Trusted Locations:
Add shared folder to trusted locations in...
consider using 'Mz-Tools' or 'Total Access Analyzer.' They are third-party tools that can help document and analyze Access databases, including command bars, buttons, and executed commands like macros, subs, functions, or popups.