February 2008

For Microsoft Access, SQL Server, .NET, and VB Professionals

Free 30 Day Trial

TOTAL ACCESS ADMIN 2007 IS SHIPPING!

Total Access Admin lets you monitor who's in your database in real time. Watch as users enter and exit your database, identify dropped connections, prevent new users, and troubleshoot multi-user problems.

New Features include support for the Access 2007 ACCDB database format, a log file for when people connect and exit, compacting the database once all users leave, command line support, and an improved user interface with Vista support. The new version supports databases created by Access 97 through 2007.

FMS Product Schedule for Access 2007

NEW MICROSOFT ACCESS RESOURCE CENTER FROM FMS

As the world's leading provider of software solutions for Microsoft Access, we've generated a wide range of material to help the Access community over the years. To make it easier for Access enthusiasts to find, we've created a Microsoft Access Resource Center, a single page to provide an overview of what's available across our web site and at FMS.

ACCESS RESOURCE: MICROSOFT ACCESS ERROR NUMBER AND ERROR DESCRIPTION REFERENCE

When an error occurs in your Microsoft Access application, Access provides an error number and description.  A complete list of all Microsoft Access 2007 error codes and descriptions is listed. We've also tabulated in a separate list, a comparison of all the Access error descriptions among Microsoft Access 2007, 2003, 2002/XP, and 2000.

Microsoft Access Error Descriptions

EXCEL TIP: SUMMARIZE SPECIFIC DATA USING CRITERIA IN THE SUMIF FUNCTION

The Excel SUMIF function allows the user a way to summarize data from one column by using criteria from a different column. The syntax and an example are as follows:

=SUMIF([Criteria Cell Range], [Criteria Value], [Number Range])

=SUM(A1:A250, “OfficeSupplies”, B1:B250)

Read More

NET TIP: WORKING WITH DATATABLE ROWSTATES

The ADO.NET DataTable object contains a lot of useful information that you might not be aware of. For each row in the DataTable you can determine the row’s state (is it original, new, deleted, modified etc.) and you can have access to the "before" values of modified rows as well as the values from rows that have been deleted. These examples show some of the things you can do to test and work with this additional information.

Find out More

MICROSOFT ACCESS CONSULTING SERVICES

Over the years, our Professional Solutions Group has provided a wide range of services for organizations interested in database applications on Windows and the web. From Access to SQL Server, Visual Basic to Visual Studio .NET, our team of professionals is here to help you with your challenges.

Here's a new description of our Microsoft Access Consulting Services. Contact us if you're interested in these or related help.

FMS ACCESS PRODUCT AND USER CATEGORY MATRIX

Not sure which of our Microsoft Access related products are right for you? We've created a new guide, FMS Access Product vs. User Category Matrix, to provide an overview of how our products apply to your situation. Let us know if it helps.

Thank you for your continued interest in FMS, Inc.
We look forward to hearing from you!

Sincerely,

Your Friends at FMS