Here are some of our resources to help you better understand and use Microsoft Access during design, development, deployment, and maintenance.
On November 12, 2019, Microsoft released a Security Update for Microsoft Office 2010 and later which causes perfectly good Microsoft Access update queries to fail.
For details, visit our page Microsoft Access Update Query is Corrupt.
Not sure when to use Microsoft Access? Wonder how Microsoft Access should fit in your organization? Here are a few resources to help you understand, justify, and position Microsoft Access to maximize its value:
These products are particularly important for Microsoft Access developers and sure to increase the quality of your development:
For automated analysis of your databases, check out our Total Access Analyzer program which is designed to examine every object in your database in detail, provide documentation to help you understand what's in it, how the objects interact, and offer suggestions for applying Microsoft Access Best Practices. It finds hundreds of types of errors, suggestions, and performance tips specific to your database objects.
During development if you have multiple copies, multiple developers, or other users making changes, differences occur and need to be tracked down. Total Access Detective compares any two MS Access databases or two objects for differences. Find exactly what changed with properties, fields, controls, lines of macro and module code, and even data between tables or queries.
Why write all the code yourself? Get our Total Visual SourceBook code library with 100,000+ royalty-free lines of code you can insert into your Access, Office/VBA and VB6 projects. Written exclusively for this professional code library, there's code you won't find anywhere else.
More info on Microsoft Access module code.
If you want to write better VBA code and do it in less time, learn about our Total Visual CodeTools program which works with Access, Office, and VB6. Total Visual CodeTools includes code builders, tools to standardize existing code (indentations, variable names, adds error handling, etc.), and tools for you to deliver more robust solutions. Learn more about our Microsoft Access coding tools.
These products are also part of our suites: