Oct 09

Microsoft Access has detected that this database is in an inconsistent state

Recently, Microsoft Access users are confronted with this error when they open their database on Windows 10 machines:

“Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During this process, a backup copy of the database will be made and all recovered objects will be placed in a new database. Access will then open the new database. The names of objects that were not successfully recovered will be logged in the ‘Recovery Errors’ table.”

‘inconsistent state’, Error 3343 “unrecognized database format

This seems to be related to Microsoft security updates that were released over the past few months.Our investigations lead us to these two links:

Microsoft Explanation

Microsoft discusses this problem here: Microsoft Access reports that databases are in an ‘inconsistent state’

Workaround

A potential workaround suggests to ensure that SMBv2 or SMBv3 is enabled on both client and server, as described in this Knowledge Base article:
How to detect, enable and disable SMBv1, SMBv2, and SMBv3 in Windows and Windows Server

We hope you find this helpful. Let us know your experience with this.

Feb 21

Microsoft Access Version Comparison Matrix

microsoftboxes2013Microsoft Access debuted in 1992 and recently celebrated its 25th Anniversary! Over the decades, Microsoft Access evolved with a large number of enhancements, database formats, features both new and old. and discontinued features.

It’s hard to remember all the changes. Fortunately, we created a comparison matrix that shows the different Microsoft Access versions and changes. See when versions were released, their latest service packs, database formats, linked tables, field types, security features, Windows Operating Systems, and many other features both new and old.

Visit our page: Microsoft Access Version Features and Differences Comparison Matrix

feature-matrix

 

Feb 15

Total Access Admin 2016 Released

real-time-monitortotal-access-adminadmin-icondownload-trial-blue

We are excited to announce our release of Total Access Admin 2016! Total Access Admin is our administrator tool to help you monitor the users going in and out of your Microsoft Access databases (ACCDB and MDB formats) in real-time:

  • adminSee who is currently connected to your Microsoft Access database (you can manage multiple databases from one screen)
  • Monitor up to 150 databases at one time
  • Keep a log of users entering and exiting each database
  • Identify workstations or users disconnecting in a suspect manner which may be the source of database corruption
  • Compact your database when all users exit it
  • Prevent new users from logging into your database
  • Log off idle users
  • Communicate with your users in real-time

New Features

Total Access Admin 2016 is an update from the 2013 version and includes these enhancements:

  • Monitors ACCDB and MDB format databases created by Microsoft Access 2016 (32 or 64-bit version) and earlier versions of Access
  • Works in environments where Access 32 or 64-bit versions is installed, including installations from Microsoft Office365
  • Does not require Microsoft Access to be installed on the machine
  • Up to 150 databases can be monitored at one time (up from 100)
  • Setup program supports Windows 8 and 10, Server 2012 and later, with an option to launch the program after its installed

database-monitor

Download the free trial version today!

Existing customers can upgrade at a discounted price.

Aug 24

Total Visual Agent Available for Microsoft Access 2016

topbannertotal-visual-agent-60scheduler

Total Visual Agent, the world’s most popular maintenance scheduling tool for Microsoft Access/Office and Visual Basic 6 (VB6) is now available for Microsoft Access 2016 (and earlier). This is the ninth major release of Total Visual Agent and introduces many enhancements to automate maintenance chores easier than ever.

To keep your Microsoft Access databases healthy, you need to regularly compact them. For disaster recovery, you should also be making backup copies of your database regularly. You may also have regular tasks such as printing reports that are performed regularly. Total Visual Agent does this and much more on a schedule you specify. Run tasks hourly, daily, weekly, monthly or just one time. Perform database chores, run Access macros or Windows command lines. A complete audit trail is maintained, and you can even be notified by email if something goes wrong. Total Visual Agent can also be run as a Windows service to restart if the machine reboots and for added security since a user doesn’t need to be logged in.

Total Visual Agent 2016 leverages our vast expertise, and offers the best database management solution with many new features:

Total Visual Agent

  • Supports Microsoft Access 2016
  • Supports Windows 8 and 10
  • Does Not Require Access to be Installed on your PC
  • Database Lock Error Identifies Offending Machines
  • Activity Log is Separated from Settings Database
  • Activity Log Shows Duration of Each Activity
  • Email Notifications Support TLS and Office365 SMTP
  • Tasks are Not Run at the End of an Event Interval
  • Enabled/Disabled Status Shown on the Event Form
  • More Robust Windows Service Feature
  • Improved Monitor Settings Tab
  • Default Location of Archive and Extract Folders Moved
  • Improved Setup Program
  • New user manual and help file
  • download-trial-blueand More…

Download the free trial version today!

Easily Define and Manage Events, Tasks, Databases and Folders

manager_2016

Jun 13

Total Access Emailer Ships for Microsoft Access 2016

Microsoft Access Email BlasterTotal Access EmailerMicrosoft Access Email

Total Access EmailerTotal Access Emailer is the most popular email blaster for Microsoft Access. Easily send personalized emails directly from your Access database. Quickly communicate with every email address in your table or query. Use fields from your data source to customize each subject and message. Attach files from disk and also attach reports as PDF files filtered for each recipient.

Total Access Emailer is now available for Microsoft Access 2016. Total Access Emailer 2016 includes many enhancements since the prior release for Access 2013:

  • Supports Access 2016
    • 32 and 64-bit versions
    • Add-in and VBA Runtime libraries in the Professional Version
  • email-validationEmail Validation to check the syntax of the values in your email field so you can flag invalid emails in your table before you send your blast
  • Save Attached Files to Disk. This lets you document the attached files sent to all your contacts without using blind cc (Bcc).
    • This can also be used independent of sending emails as a way to distribute files and PDF reports to disk. You can even create folder names based on field values.
  • Preview Saving Files to Disk
  • New VBA Function to Preview Email Blasts with Save Files
  • Code Generator Supports Preview Email with Save Folder
  • Enhanced setup for Windows 10 and 64-bit installations
  • Updated user manual and help file
  • Complete list and additional details of new features.

download-trial-blueDownload the free trial version and send your own personalized emails from Microsoft Access.

Easily Run and Manage the Email Blasts You’ve Created in Your Database

Main Screen of Total Access Emailer 2016