Jul 10

Microsoft Access Class Not Registered Run-time Error -2147221164 (80040154)

Microsoft Access Triggers a Runtime Error ‘-2147221164 (80040154)’: Class Not Registered

This error occurs in a Microsoft Access database that seems to work fine on every other machine but one. The MS Access database actually loads and runs, so the code is compiled and functional. Then it dies on some very common code such as CurrentProject.Connection for ADO to open a table or query recordset:

Microsoft Access "Class Not Registered" Run-time Error -2147221164 (80040154)

Confusion

The “Class Not Registered” is very confusing. It implies code that won’t compile or broken library references but that’s not the true cause. Is the Access database corrupt? No.

We’ve received reports for this error for years and were never able to reproduce it. We finally did and figured out why it occurs and how to fix it. Read our new paper Microsoft Access “Class Not Registered” Run-time Error ‘-2147221164 (80040154) to learn more.

Jun 06

Total Access Emailer Ships for Microsoft Access 2013

Total Access EmailerTotal Access Emailer is the most popular email automation program for Microsoft Access. It simplifies the sending of personalized emails with Access data and reports to everyone on your list.

Total Access Emailer is now available for Microsoft Access 2013. Total Access Emailer 2013 includes many enhancements since the prior release of Total Access Emailer 2010 and the Version x.6 for pre-Access 2010 versions:

  • Enhanced setup for Windows 8 and 64-bit installations
  • Supports differences in VBA code between Microsoft Access 2013 and 2010
  • Improved support for linked tables in SQL Server and Access databases including situations when connections are lost
  • User interface improvements to better manage editing and duplicating email blast specifications
  • Professional Version VBA library detects if the user’s machine has not run the runtime distribution EXE
  • Improved display of record counts for repeating multiple email blast broadcasts
  • Improved error handing and reporting
  • Updated user manual and help file

Here’s a complete list of new features.

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

Apr 14

Microsoft Access Videos from the SharePoint Conference

Microsoft Access ProductsMicrosoft SharePointThe Microsoft Access team has released videos of their presentations at the SharePoint Conference from Las Vegas, NV.

With Access 2013, Access web solutions are hosted in SharePoint and rather than using SharePoint lists as they did in Access 2010, they use a real SQL Server database hosted in SQL Azure. The database can also be linked from desktop copies of Access to create hybrid solutions that serve both the web and Windows.

The Microsoft Access program managers presented these four sessions:

Enjoy!

Other Videos from FMS

Mar 22

Total Visual Agent Ships for Microsoft Access 2013 and 2010

Microsoft Access Database SchedulerTotal Visual Agent for Microsoft Access DatabasesAutomate Microsoft Access Database Compact and Other Chores

We are very pleased to announce that Total Visual Agent 2013 is now shipping.

Don’t Forget System Administration for Microsoft Access Database Solutions

A professional Microsoft Access database application needs ongoing system administration. It’s an area that many MS Access developers neglect and causes problems when things go wrong (database corruption, missing backups, disaster recovery, etc.):

Enterprise Quality System Administration with Audit Logs and Email Alerts

Total Visual Agent has provided an Enterprise Quality solution for almost 20 years by giving organizations a reliable way to perform their critical tasks on a 24/7, 365 days a year basis. A detailed audit log documents each action that is performed, and sends emails if errors are encountered.

Schedule Events, Databases, and Actions to Perform

Total Visual Agent automates and schedules Microsoft Access tasks. It ensures repetitive tasks are completed reliably. Tasks such as database compact and repair, zipped backups, rolling backups (e.g. 7 copies for each day of the week), running macros, running Windows command lines, making copies of table data, collecting database statistics such as size and record counts, etc. Easily schedule tasks for the middle of the night and know they’ll be completed.

Events can be scheduled every X minutes, hourly, daily, weekly, monthly or just one time. You can specify the days of week and time periods that it runs to limit processing to off-hours. Select the databases and directories (including subdirectories) to manage with support for workgroup security and database passwords.

Includes a Windows Service for Secure Processing and Reliability

Once defined, the events and tasks can be run by our Monitor program that is a standard Windows program.

Alternatively, Total Visual Agent includes a Windows Service, so you can run your tasks without having anyone logged on the machine. The Windows service is a more secure, robust solution since it can automatically restart if the machine reboots.

New Features in the 2013 Version

A huge number of new features were added in this 2013 release from the previous 2007 version:

  • Microsoft Access 2013Support for Microsoft Access 2013 and 2010, plus 2007
  • Support for 64 bit Operating Systems
  • Simplified Startup and Easier Management of Multiple Microsoft Access Versions
  • Import Settings from Multiple Versions of Total Visual Agent
  • Test All Actions for an Event, Database, Directory or Task Group
  • Create Events that Run Every X Minutes
  • Create Events that are Limited to Periods Spanning Midnight
  • Process Directories with Managed Databases
  • Data Extract Tables are Keyed
  • Run Macros for Database Password Protected Databases
  • Pause for a Fractional Minute
  • Compressed Archive File Names Support Multiple Extensions
  • More Detailed Activity History Log with Deletions
  • More Detailed Database Statistics with Deletions
  • Add Your Comments to Events, Directories, and Actions
  • Simplified Addition of New Actions
  • More Modern and Improved User Interface
  • New User Manual and Help File

For complete list, visit: New Features in Total Visual Agent 2013

Download a Free Trial Version

A fully functional trial version is available for download so you can run it on your system with your databases

Contact Us

  • Visit our Support Site if you would like to submit any questions to our technical support team.
  • Place an order online. Existing customers can upgrade at a discounted price.
Jan 27

Helping Create Living Wage Jobs with YearUp Featured on CBS 60 Minutes

YearUpOver the past few years, I’ve had the pleasure of working with and supporting the Arlington, Virginia chapter of YearUp. YearUp is a non-profit organization helping at risk youths get out of a lifetime in minimum wage jobs and toward a career path with a living wage.

They not only teach marketable skills, but supplement it with the personal and business soft skills necessary to be successful in business. They have particular focus teaching computer hardware skills, help desk, and basic finance. They understand and address employer needs: “We know you hire for skills, and fire for behavior in the work world.” By learning what companies and bosses expect, these youths are able to better understand what it means to be a professional, provide more value to their employers, and justify earning a higher salary.

Both FMS EVP Michelle Swann-Renee and I have met the students in person to discuss what employers seek and how to differentiate oneself positively in the workforce. As employers, we need people who arrive with skills we can’t train: honesty, work ethic, personal drive, high standards and expectations of one’s performance, getting along with others, ability to accept constructive criticism, writing and speaking skills, common sense, etc. Specific technical skills can be taught and change over time; those basic skills and character traits are difficult for a company to train. We’ve been impressed with the dedication of the staff and eagerness of the students to take the opportunity to learn and succeed. Those who make it through the program are very likely to be successful in a career and further education.

60MinutesLast night, YearUp was featured on the CBS 60 Minutes episode by Morley Safer: Jobs program aids Fortune 500 and underprivileged youth

Hope you get a chance to check out and support this program.