Feb 15

Luke Chung Speaking at Portland Access User Group Conference in May

FMS President Luke Chung will be attending and speaking at the three day Microsoft Access conference sponsored by the Portland Oregon Access User Group.  Join him and other guest speakers including Alison Balter from InfoTech Services Group Inc., Armen Stein from J Street Technology, and Kevin Bell from Microsoft.

Luke will be speaking on the following topics:

  • FMS Products for Microsoft Access Developers and How they Make You Money
  • Microsoft Access and Azure: Working in the Cloud
  • Microsoft Access Disaster Recovery Plans

For complete details visit PAUG 2011 Database Designer Conference and see you there May 14-16

Feb 14

Luke Chung Presenting at the Denver Area Access User Group April 5th

FMS President Luke Chung will be the guest presenter at the April 5th meeting of the Denver Access User Group. He'll be discussing Microsoft Access 2010, FMS products for Microsoft Access, and all things Access. See you there!

DAAUG Meeting
April 5, 2011 from 6 to 9PM
Microsoft USA – Rocky Mountain District
7595 Technology Way
Suite 400 (4th Floor)
Denver, CO 80237

 

Jan 04

Total Access Admin for Microsoft Access 2010 is Shipping

Total Access Admin lets you monitor your Microsoft Access databases to see who's currently in it. It's ideal for understanding who's currently connected, compacting databases after everyone has exited it, and troubleshooting multi-user problems.

The Total Access Admin 2010 supports Microosft Access 2010 and 2007. In addition to supporting Access 2010, it now lets you monitor multiple databases in one screen. You can perform actions across all the databases, watch the activity in real time, log the users entering and exiting each database, and compact the database after everyone exits. Visit the New Features page for all the enhancements.

Total Access Admin 2003, version 11.5, is also released for Access 2003 and earlier.

Free Trial versions of both versions are available.

Sep 29

Total Access Statistics for Microsoft Access 2010 is Shipping

Microsoft Access 2010Total Access Statistics 2010

We are very pleased to announce Total Access Statistics for Microsoft Access 2010 is now shipping, along with updates for earlier versions of Access. Total Access Statistics is the most popular data analysis program for Microsoft Access. It extends the data analysis capabilities of Access queries to let you perform advanced numerical analysis on your data. Use any Access table, linked table, or query to perform calculations such as percentiles, regressions, frequency distributions, t-Tests, correlations, non-parametrics, rankings, moving averages, etc. It can also perform data normalization and let you select random records. As you would expect in a query, you can specify Group By fields so analysis is performed on each set of records with identical group fields.

Total Access Statistics runs within Access with all output in Access tables. It supports MDB, ACCDB, and ADP databases.

In addition to supporting Access 2010, we've added Financial Calculations for Cash Flows. It now calculates net present value (NPV), present value (PV), future value (FV), internal rate of return (IRR), and modified internal rates of return (MIRR). There's support for both the 32 and 64 bit versions of Access 2010. It includes both the interactive wizard that runs as an add-in, plus the programmatic VBA library so you can embed statistical analysis in your applications.

Here is additional information for:

Free demo versions are also available for you to download. 

Aug 19

Speed Up Microsoft Access and Visual SourceSafe Integration

Microsoft Visual SourceSafeMicrosoft AccessUsing Microsoft Visual SourceSafe (VSS) with Microsoft Access for system development is great for tracking old versions, maintaining a professional Access development platform, and multi-developer environments. Being able to quickly see old versions of individual objects, differences over time, and check-in and check-out objects to prevent multiple developers from changing the same object are all wonderful features. Visual Source Safe is part of MSDN. By installing the Office/Access developer extensions/edition or Visual Studio Tools for Office (VSTO), VSS gets added to your Access menus.

Unfortunately, as Access databases get more objects, VSS slows down and can sometimes take minutes to add a new object to the database. Waiting for VSS to prompt you for every new object not only wastes time (especially if you don't want to add a temporary object to VSS), it disrupts the rhythm of system development. Fortunately, there's an easy way to work around this. Read this paper Speed Up Microsoft Access and Visual SourceSafe Integration for details, including Access 2010.