Access Database Tutorial

You maybe starting to think that Microsoft Access is a buggy and is a ‘full of bugs’ application becoming very unstable indeed but the complexity and the power of what MS Access provides out ways some minor and silly errors that can occur. Error code 3047 refers to records being too large for a database file and typically triggered when attempting to import data from another external application. The common method you will see this is when you use the DoCmd. TransferSpreadSheet   method which is a VBA command to import and export datavia typically Excel. Ironically, Microsoft Access is a large database management tool but still has issues handling the wrong size type of data and there are size restrictions (even for the latest 2016 version). As a reminder, take a look the   specification sheet for Microsoft Access   to know what limits are set so you can determine the correct methods for data migration and population – it may help and avoid the time-wasting err...

Who says software is perfect? Microsoft Access database is no different and can suffer to either poor programming or bad computer memory, cluster blockages or fragmentation build up. One common error code seen (but not often arises) in your MS Access is “ Error 3112 ” with a supporting message implying records cannot be read; no read permission for a particular table or even a  system table  (which is normally hidden). So, when working on your Microsoft Access database and opening either a MDB/MDE/ACCDB/ACCDE file, and you see this unexpected error “Record(s) cannot be read; no read permission on ‘….’ ”, you can assume somehow your database file has become corrupted.Also, you may also come across the same error code 3112 if you are trying to access a file for which you do not have the required amount of permissions but then again, you should have a better handle on the latter. However, if you have full access and there no restrictions to a file in your server (or cli...

There are various formatting choices that give flexibility and make reports more efficient.  Microsoft Access 2016  has a  report Wizard  (as a starter point) that walks you through the process of creating a report. The report look and feel will greatly depends on the user’s requirements. The more complex it gets, the higher the degree of customization is needed. The greatest strength of any report is in its structure. If the report is informative, it will surely stand out. You can improve your reports by inserting headers and footers, adding logos, and changing color combinations. In this blog, you will learn how to insert time and date into the header and footer sections of your  Microsoft Access 2016    report. Header and Footer Sections The header section...

7 Reasons Why Microsoft Access Database Should Be Used First of all, let’s clear up what is actually a Microsoft Access Database library. Simply put, it’s a code library or code database when programming your Access database (using VBA code) and is used to manage and access other objects from other applications and sources that are deemed external to MS Access. Therefore, to communicate with say Microsoft Excel or Microsoft Outlook, you would need to first enable and allow permission to use their respective library files before VBA could talk and work with these applications and is provides a layer of security and control how objects are utilised. So, we are talking about programming Microsoft Access Database using VBA code and it’s not uncommon to have to enable add references to other applications and objects. By doing so, you are really just re-using existing and predefined code to manipulate objects in a certain way and help to quickly build powerful procedures...