Reposted here from MS Community Forums based on replies there:

Hello,

Where I work I seem to have found some bugs in MS Access 64 bit (not in 32 bit) relating to using VBA to call update queries.

When calling an Update query from the current database via a 'qdf' object that has one or more long text fields to be updated, and supplying the values for those updates via Long Text parameters, it seems that supplying either a 1 or 2 character value can cause Access to crash when the qdf is executed, depending on the position of the parameter in the list of parameters in the query definition. If the parameter is later in the list, an invalid argument error is thrown instead.

There is also an additional bug where a leading or trailing backslash causes an invalid argument error. This also seems to affect short text fields.

I don't know how to report these bugs to MS directly which is why I've posted here.

Ian

Office 64 bit = Version 1808 (Build 10730.20264 Click-to-Run)

I don't have the code available to me at the moment, but I will see if I can reply with an example soon.

Ian J.

Introduction

Microsoft Access is an application for database which a lot of companies, schools, colleges, and universities are using it in order to manage the information of their employees or students. Our project tending to make Microsoft Access easier to be used by its users by improving the security of the databases and the ease of entering the information into these databases. Nowadays the barcode scanners are popular in almost everywhere, and the QR scanners. Our project is to link a barcode/QR scanner to Microsoft Access in order to make it easier to enter the information to the databases and it will be faster. A part of our project is the security for these databases because the information in these databases must be used only by the authorized people not for everyone.

Microsoft Access has a basic security option which is encrypting the database by a password which is king of easy to hack it or break it. In order to make the hacking or braking through the password harder, we thought about linking a security device to Microsoft Access in order to keep the databases safer. In the current version of Microsoft Access, we need an intermediate software in order to link the software of the security device in order to work properly. The problem in this intermediate software is they are very expensive because they considered to be luxuries which people use it to make their work easier. We thought about providing Microsoft access with the direct ability to accept any security device which it needs to be linked to it without any intermediate software in order to make the luxuries things public to let the people use it as if it is basic things with a little higher cost for Microsoft Access. 


Microsoft Office has only one way to enter the data into the tables which is by typing the data into the form which is related the targeted table. Sometimes this way is hard for some people who are using Microsoft Access. Many people on Microsoft website were asking in their comments about a faster way to enter the information into the table because they are having hard time entering the information to the tables by typing because there are a lot of information they have to enter them to their databases, so the people were asking if the barcode/QR scanner could be able to be linked to Microsoft Access or not, and what are the requirements to link a scanner to Microsoft Access. The solution is very easy, but it is very expensive. The solution is an intermediate software has toby installed to link the software of the scanner to Microsoft Access in order to work properly then the user can choose which form will use to enter the data into it. Our project is tending to let the users to link the barcode/QR scanners without any intermediate software with a little bit higher cost for Microsoft Access.   

Microsoft Access has no dark mode option although the new updates for the other database applications provide dark mode nowadays. People like the dark mode in the applications because it relaxes their eyes when they stay a long time in front their computers. In our project we tending to provide Microsoft Access with the dark mode option in order to let the users feel comfortable while using the application, and to be able to read the information clearer than the light mode.

The good database application is the application which suits all the computer devices. Although Microsoft Access is a very good database application, apple users cannot use Microsoft Access on apple computers. It has been a big problem for many people specially students that they cannot use Microsoft Access on their apple computers because it is not supported in apple computers. Our project is to let apple computers to support Microsoft Access in order to be reachable for all the users.

Requirements

Microsoft Access is a good database application, so it deserves to be improved in order to be easier and more secure. In order to make Microsoft Access easier to be used by the users, we need to add the ability to link the barcode/QR scanner into it directly without an intermediate software. The requirements are as follows; we are going to post an update for Microsoft Access which will contain a built-in software to link the scanner device directly to Microsoft Access. The built in software will let the user to choose between the forms which related to the deferent tables in the database in order to let the user scan the barcode or the QR code in order to enter the data into the targeted form. The software will also let the user to choose the way by which he/she can enter the data with; the choices will be between entering the data by typing or entering the data by the scanner. The software will ask the user if he/she wants to keep a default form when starting the data entry proses, or the user must choose every time between the forms in order to get every data in its suitable table.


Microsoft Access has a basic security system which is encrypting the database to be unlocked by a password. Our project is to add the ability to Microsoft Access to link security devices without an intermediate software. We need to post an update to Microsoft Access which has a built-in software to let Microsoft Access to link with the security devices directly. There are many security devises such as the fingerprint reader, the face identification device, the tooth identification device, the eye print reader, and a proxy card reader. The built-in software will ask the user if he/she wants to encrypt the database by a password as the basic way or to use the security device to encrypt the database by ether ways according to the security device by putting your fingerprint to encrypt the database and also use your fingerprint to unlock the database to open, or by any way which the security device provides you to encrypt and to unlock the database. The built-in software will ask to add one or two as maximum persons to be the administrators to save their identities because it cannot be open for everyone in order to keep the databases safe abs accessible by the authorized people only.

Most of the updates for database applications provide the dark mode to their users. In order to provide Microsoft Access with the dark mode option, we need to post an update for Microsoft Access which provide the users with the dark mood option. Microsoft Access will ask the user if he/she wants the appearance to be on the dark mode or on the light mode when the user start setting up his/her account on Microsoft Access then the user can later change the appearance from the settings of the application when the user wants.

Many people epically the college students facing problems when they try to use Microsoft Access on their apple computers because Apple computers do not support Microsoft Access. We will design a software on Appstore studio which will let Apple computers to install Microsoft Access without facing any problems like the Android Emulators and IOS Emulators on the computers which they allow the users to install the Android applications and IOS applications on the computer, so the software which we will design will be on the same way of these applications, but it will be designed to install Microsoft Access on Apple computers easley.