note

[ Access ] You can build internal systems too!

The other day, I wrote an article titled "Basic Usage of Microsoft Access". Towards the end of that article, I wrote something to the effect that "Access is a low-end version among RDBMS, and its ...
GitHub

Example Active Directory LDAP Query in VBA.vba

sDN = "cn=" & sUser & ",dc=IT Accounts,dc=intranet,dc=example,dc=ch" 'Look up the destinguished name (DN) of your account with which you are trying to login to the ...
Interesting Engineering

Here’s how you can connect Microsoft Access to SQL server

Logos of Microsoft Access and SQL on a blue background.Interesting Engineering MS Access is a popular desktop database application that allows users to store and manage large amounts of data. However, ...
GitHub

Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file

/decompile Undocumented command line. Will sometimes remove old code and objects from the database and make it faster. /excl Opens the specified Access database for exclusive access. To open the ...
TechRepublic

How to print one or more labels for a single Access record

It’s easy to print a single label for one or more records, but when you need to print multiple labels for a single record, you’ll need VBA. We may earn from vendors via affiliate links or sponsorships ...
Microsoft

Power Tip: Improve the security of database connections

This post about making ODBC connections more secure is provided by Access MVP Ben Clothier. Now and then, we come to a point where we decide to upsize an Access database to a server-based RDBMS. The ...
TechRepublic

Learn the differences between Is Null and IsNull() in Access

How many null values exist? What is the difference between a null value and a blank entry? This article answers those questions and more by discussing what to look for when creating Access apps that ...