If you’re like me, you’re always looking for ways to streamline and simplify your work. To that end, I long ago started developing a routine to take databases I develop and ‘configure’ them for deployment. What type of thing does my code do?
It is that last point that I thought I’d share with you today.
Continue reading
Have you ever had one of those users that open the database, does other things, comes back and opens another instance, … and so it goes.
Maybe it’s time to minimize the issues this can cause by limiting a user to only being able to launch a single instance of a given database.
Continue reading
Microsoft Access Shift Bypass is a feature that allows users to open an Access database without running startup options or AutoExec macros. This functionality can be crucial for developers and administrators but may pose security risks in deployed applications.
When opening a Microsoft Access database, users can hold down the SHIFT key to bypass startup properties and the AutoExec macro. This feature is particularly useful for troubleshooting and accessing databases that might have errors in their startup code.
Continue reading
In the world of data management and calculation, rounding numbers is a common operation that seems straightforward at first glance. However, when comparing the rounding method used in Microsoft Access to the traditional numeric rounding taught in schools, significant differences emerge. These differences can have important implications for data accuracy.
Microsoft, in the official Access Round documentation, states:
In educational settings, students are typically introduced to a simple and intuitive rounding method:
Continue reading
I thought I’d simply share a function I devised to help someone out on UtterAccess in case it could help someone else out there.
The question that was originally asked was:
So, basically asking how can we rename a macro in an external database.
Visual Basic for Applications (VBA) is a powerful tool for automating tasks in Microsoft Office applications. One common requirement in programming is to concatenate strings, especially when dealing with names. However, handling null values can lead to unexpected results. In this article, we will explore two methods of concatenation in VBA: using the ampersand (&) and the plus sign (+). We will also discuss how to manage null values effectively.
Concatenation is the process of joining two or more strings together. In VBA, this can be achieved using either the `&` operator or the `+` operator. While both operators can be used for string concatenation, they behave differently when encountering null values.
Continue reading
I’ve been debating about writing such an article for a long, long time now, but with the incessant issues with Access, Microsoft effectively killing Outlook, I believe the time has come to stop beating around the bush on this one.
Today, I wanted to present to you a few of the main reasons why considering a move to Web Application development may be the better choice. I am primarily focusing here on PHP, however most comments below would just as easily apply to .net, … or any other proper web development language.
Okay, let’s dive in!
Moving from Microsoft Access to PHP web applications offers several significant advantages for businesses and developers.
Continue reading
A new issue has emerged in Microsoft Access Version 2412 (Build 18324.20092 Click-to-Run) that affects users relying on the MouseWheel event. This bug could impact scrolling functionality in various applications.
Version Affected: Microsoft Access Version 2412 (Build 18324.20092 Click-to-Run)
Issue: The ‘Count’ value in MouseWheel events is reportedly always returning zero (0) instead of -1 (scroll up) and +1 (scroll down). Others are now stating the all Mouse events seems to be impacted beyond just the Count value.
The Dev Team has just informed us that the fix to this issue will be part of Version 2501.
The Good news is that people have stated that the update is out, so update your systems and you should get Version 2501 (Build 18429.20044 Click-to-Run) installed.
The BAD news is several people in the discussions and in the Feedback Portal suggestion comments have already stated the update to 2501 did not fix this issue.
Version 2501 (Build 18429.20132 Click-to-Run) appears to resolve this issue as confirmed by multiple sources now. So be sure to update your Office installation to this latest build.
The original report of the issue was made by Ross Story dated 2024-12-26, now others have added their voices to his discussion on the matter, and can be found in the following post on Microsoft Answers:
Indexing boolean fields in databases is a topic that often generates debate among database administrators and developers. The primary question revolves around whether the performance benefits of indexing these fields outweigh the potential downsides, particularly in terms of write performance and storage efficiency. This article explores the nuances of indexing boolean fields, examining when it is advantageous and when it may be counterproductive.
Boolean fields are data types that can hold one of two possible values: true or false. Given their binary nature, one might assume that indexing them would be straightforward; however, the effectiveness of such indexes can vary significantly based on several factors, including data distribution and query patterns.
Continue reading
Microsoft Access is a powerful database management tool that allows users to create, manage, and manipulate data effectively. One of the core functionalities of Access is its ability to execute queries, which are essential for retrieving and modifying data within a database. This guide will explore the different types of queries available in Access — SELECT, INSERT, UPDATE, and DELETE —along with their applications in data retrieval and manipulation.
Continue reading