Author Archives: Admin

Jan 22

Microsoft Access Percentile Calculations with Total Access Statistics

Posted on by


Total Access Statistics is the world’s most popular data analysis program for Microsoft Access. It runs as an Access add-in to let you extend the numerical analysis capabilities of Microsoft Access queries.

A common need among MS Access users and developers is the need to calculate percentiles. We’ve created a new page providing more details on how to Calculate Percentiles in Microsoft Access with Total Access Statistics. Percentiles can be generated on the data from your table or query, and are provided in three ways:

  • A new table with each percentile value as a separate field
  • A new table with each percentile value as a separate record
  • Updating a field in your table with the percentile value corresponding to the data in your record

Download the Total Access Statistics trial version to see for yourself on your own data.

Jan 22

New Updates for Total Access Detective for Microsoft Access

Posted on by

Microsoft AccessMicrosoft Access Database and Object Comparison ProductTotal Access Detective for Microsoft AccessFind Differences Between Microsoft Access Objects and Databases

Total Access Detective is our popular Microsoft Access database, object, and data comparison product. Compare any two databases or two Access objects in one database to pinpoint exactly how they are different. As part of our commitment to quality, we are pleased to announce that we have released new updates for:

These updates include performance enhancements, Windows 7 support, improved ADP support, and resolve all known issues since their original release. For more details, visit the Total Access Detective Updates page.

The updates are available free of charge to registered owners who were notified via email. If you did not receive instructions, please contact us so we can update your information.

Oct 23

Access Tip: Simulating the Microsoft Access Runtime Version during Development

Posted on by

The Microsoft Access runtime version allows you to distribute your Access applications to users who do not have a full license of Access. The runtime is similar to the full version of Access, but several of the features that exist in the full version are not available in the runtime. To test your users’ experience, you can simulate the runtime with a command line.

To learn more, read our tip: Simulating the Access Runtime during Microsoft Access Development.

Oct 23

Update Query and SQL Syntax in Microsoft Access

Posted on by

Related to our detailed paper on Query Tips and Techniques, we added extra information on the basics and syntax of an Update Query in Microsoft Access.

We also have a related article on dealing with non-updatable queries: Error 3073: Operation must use an updatable query: Dealing with Non-Updateable Queries and the Use of Temporary Tables in Microsoft Access.

Oct 16

Save Your Job, Relationship, or Client by Delaying Your Outlook Messages

Posted on by

Have you ever wished you could bring back a message after you press the Send button in Outlook?  Maybe you forgot to add an attachment, or maybe an email came in while you were writing your message that changes what you want to say.

Or maybe you were a bit too hot headed, and that message really should be deleted. No matter what, Outlook offers a feature that I love, which is the abilty to delay mesages in my Outbox for a few minutes. My two minute delay has saved countless blunders.

Here's our Microsoft Outlook tip on delaying messages that describes how to avoid these career and relationship ending mistakes.

Oct 09

Speaking at Office Devcon 2009 in Australia Oct 31 – Nov 1

Posted on by

I’ll be giving several presentations on Microsoft Access application development and our products at the Office DevCon 2009 conference in Brisbane, Australia at the end of the month. Hosted at the University of Queensland, St. Lucia campus, I hope you see you there!

For more information, visit our Upcoming Events page.

Oct 06

Access Tip: Reference Tab Pages by its PageIndex Rather than Tab Value on Microsoft Access Forms

Posted on by

Here's a simple tip to avoid problems associated with referencing the individual pages (tabs) of a Microsoft Access tab control in VBA.

Tabs are powerful and easy to use on Microsoft Access forms. A tab control contains pages (tabs) with each page identified by its PageIndex property starting with 0. The value determines the order of the tabs. However, if you reference the pages by number, your code may fail if the pages are reordered, new ones added or pages deleted. 

See how you can avoid this problem and read about other tips for creating better and faster Access forms.

Sep 04

Use Link Analysis to Visualize Your Data

Posted on by

Link AnalysisWe are all used to seeing the 'rows and columns' metaphor when looking at data. In fact it is the primary interface for many of our data analysis tasks.

But rows and columns can hide valuable patterns. What happens when you take data out of a database and visualize it as a network? Now you can see important connections, centrality, trends, movement over time, and many other key indicators.

Check out our article on Link Analysis and Social Network Analysis to see how our Sentinel Visualizer solution provides innovative ways to get more meaning from your data.

Sep 01

Errors Importing Data from a Microsoft Access 2007 Format File into SQL Server

Posted on by

While attempting to import an Access 2007 format database (*.ACCDB), you may receive an error such as: Unrecognized Database Format or Could not find installable ISAM. These errors can occur if you do not have the appropriate driver installed to import data from ACCDB files.

Importing Microsoft Access MDB databases into SQL Server is a built-in feature of SQL Server. However, because of the difference between the database engine of Microsoft Access 2007 and earlier versions of Microsoft Access, it is not possible to connect to the Access 2007 database using the built-in data source “Microsoft Access”. You can use this if you wish to import data from a MDB format, but not an ACCDB from Access 2007. For more information, check out Errors Importing Data from a Microsoft Access ACCDB Database Format into SQL Server.