Tag: Access
-
DSNless Connection in VBA to SQL Server Tables
When we released updated access database which were linked to an sql source the deployment requires re-connection to the client environment ; We would need to ensure the client PC had the DSN setup and tested, to simplify the process we call this DSN-less function. The program tests the connection when opening and advises the…
-
Deploying Access Databases
When deploying Access databases, it’s essential to enforce best practices for both security and performance. One key strategy I follow is ensuring users only run the program from a local location, such as their personal PC or the My Documents folder, rather than directly from a shared server. The program is linked to either a…
