Search results

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...

thanks for sharing Thank you

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...

It's frustrating to discover that SSMA didn't convert the hidden FK indexes in your Access application. It seems like an unnecessary manual step. Have you tried reaching out to Microsoft support for insights or a potential fix? Regarding SQL Server 2022, it's not uncommon for newer versions to...

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.

Hello everyone myself gregbowers I am new here