On Monday evening September 8th, I’m the featured guest speaker for the Microsoft Access User Group in New York City.
Microsoft Corporation Headquarters
1290 6th Avenue
between 51st and 52nd Streets
Hosted at Microsoft’s offices in midtown, I’ll showcase some of our products and work with Microsoft Access. I’ll also answer any questions about my experiences with technology, media, and business.
Join me at this free event. More details to follow. Link to other Upcoming Events.
Total Access Statistics is the most advanced data analysis program for Microsoft Access. It extends the power of Microsoft Access queries with a wide range of statistical calculations including percentiles, frequency distributions, correlations, regressions, rankings, running totals, financial cash flow analysis, data normalization, crosstabs with Chi-Square, t-Tests, ANOVA, non-parametrics, probabilities, and more.
Total Access Statistics is now available for Microsoft Access 2013. Total Access Statistics 2013 includes many enhancements since the prior release of Total Access Statistics 2010:
- Support for the 32 and 64 bit versions of Access 2013 with separate add-ins for each
- New redistributable runtime libraries to support Access 2013, 2010, 2007, and 2003
- Support for Windows 8 (and all Windows versions supported by Access)
- Improved performance when analyzing large data sets
- For Percentiles, when assigning percentile values to a field in your table, you can specify calculations such as quartiles, quintiles, octiles, deciles, etc. rather than just percentile
- Field format is set to Percent for percentage fields in the Frequency, Crosstab (when percentages are in columns), and Chi-Square details tables
- When tables are generated from the add-in, the field column widths are resized to show the entire field name and data
- Updated user manual and help file
Here’s a complete list of new features. For more information visit these resources:
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:
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.
Total 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 the free trial version and send your own personalized emails from Microsoft Access.
The 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:
Other Videos from FMS