DBA – MySQL, PostgreSQL, MongoDB, Oracle
Posts about Microsoft Access Database development, configuration, errors, fixes, optimisation issues.
Background: For the purpose of taking backup of the MS access database, VBA script failed for one of the tables of the source database, showing “Property not found Error: 3270“. Resolution: Compact and repairing didn’t solve the issue, recreated the table also didn’t help. Upon further dig down its been observed that removing the “Calculated”…
Background: All of a sudden importing data from spreadsheet in a form produced the above error(it was tested and worked fine over two weeks), the same operation in another form is executing fine. This is bit frustrating when everything seems fine, no errors in logic or elsewhere but things are not working. Solution: Digging down further…
Background: To make the user interface more friendly in nature it’s a good approach displaying an Alert Message when MS Access Query returns no value to its corresponding recordset. How To: By using the MS Access RecordsetClone and RecordCount Property we can return a message with an empty recordset. If Me.RecordsetClone.RecordCount <= 0 Then MsgBox (“No records…
Background: In the recordset update form execution the “Ms Access Error:Run-time error ’94’: Invalid use of Null ” Workaround: Generally this error shows up when a variable’s or a control’s in an operation has no value at all i.e NULL. Upon further investigation it seemed that the “Me.txtamount” has no value as in some stage…
Background: While updating a record set the MS Access Error: Run-time error ‘3061’ showed up. Workaround: Upon investigation found the column in WHERE clause supplying wrong type of value. In the below code the [suppid] is of String type but the value supplied ” & suppidVar & “” is not a String.
MS Accès Errors
Background: Sometime it needs calling sub routine in MS Access VBA on another form or in same form to perform certain tasks on the current intended command execution as a pre-requisite of the process. There might also be needed to call a subroutine on the main from the sub-form. In addition to that calling the sub-routine from another…