Recent News from FMS
Visit our Blog for the latest news
 Portland
Oregon Microsoft Access Database Designer Conference
Silver Falls State Park Conference Center
May 5-7, 2012
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 at the beautiful Silver Falls State Park Conference Center.
Microsoft speakers include Ryan McMinn, Microsoft Access Senior Program
Manager Lead, and Kevin Bell test engineer on the MS Access team. Other
speakers include industry authors and notables F. Scott Barker, Alison Balter,
Juan Soto, and Armen Stein.
Luke will be giving a new presentation on Tips and Techniques
for Taking Over and Existing Access Application.
For complete details and registration, visit
PAUG Conference Site.
See photos from last year's conference on our
Facebook page.
  
Total Access Detective Ships for Microsoft Access 2010 with Updates for 2007
and 2003
We are pleased to announce the release of
Total Access Detective for Microsoft Access 2010 with support for the 32
and 64 bit versions of MS Access 2010. We've also released an
X.8
Version update for Microsoft Access 2007 and 2003.
Ever wonder what changed between your database versions or the difference
between two similar objects or tables? Total Access Detective is the premier program to detect differences
between Microsoft Access databases, objects, code, and data.
Available as a Microsoft Access add-in, Total Access Detective lets you
easily find differences between objects in your currently opened database.
Easily find changes in your table and field definitions, object properties,
controls, report sections, embedded macros, regular macros, modules, and
data. The results are available to you in reports and on screen which can be
copied or exported.
You can also compare any two databases to easily find exactly how they
changed. Your databases can be an ACCDB, MDB or ADP database format. The new
version lets you create separate databases for each comparison so you can
easily manage multiple databases and changes over time.
We've added many
new features to make Total Access Detective more powerful than ever:
- Supports Microsoft Access 2010, 32 and 64-bit versions
- Compares All Database Types Supported by Access 2010
- Compares the new Microsoft Access 2010 enhancements including new
object properties, macro syntax, and VBA commands
- Performs Line-by-Line Comparisons of Embedded Macros
- Procedures that Did Not Change are Listed
- New Data Comparison Option to Ignore Case Differences
- When Comparing Modules, Optionally Ignore Blank Lines and Comments
(also applies to text block comparisons)
- Exclude Properties from Comparison
- Create and Manage Multiple Database Comparison Results. You are no
longer limited to one set of comparison results!
- Command Line Launching of Total Access Detective Can Now Specify
Storage Database Name
- Improved User Interface with Office/Access 2010 Theme Support
- New Reports and Improved Selection Screen
- New User Manual and Context Sensitive Help
Manually comparing databases for design and data differences is prone to
error. Discover why so many Microsoft Access professionals rely on Total
Access Detective to improve their productivity by quickly identifying the
changes in their work.
  
 Total Access Components 2010 Ships with 32 and 64 bit Controls
Create dazzling forms with
Total Access Components,
the only collection of custom controls designed specifically for
Microsoft Access.
With little or no code, add advanced menus, rotated text, bitmap
animation, resizer and splitter bars, progress meters, gauges,
dials, sliders, spin buttons, pop-up notes, Windows dialogs, clocks,
fancy buttons, borders, rotated tabs, cursors, etc. A sample database
includes examples of every control and how to customize them.
The 2010 version is rebuilt using C++ version 10 and supports both 32
and 64 bit platforms without having to make any changes to your
forms or code.
Total Access Components 2010 supports Access 2000 through 2010. It
includes a royalty-free distribution license and a deployment
program to easily distribute it to your users. Here are the
new features.
You can also download a
free trial
version.
  
Total Access Startup for Microsoft Access 2010 is Now Shipping
Total Access Startup
2010 (Version 14.0) lets you centrally manage and guarantee that all your
users always launch the right version of Microsoft Access with the right
version of your Access database (MDB, ACCDB, or ADP). Simply distribute a
shortcut to your users to start your application. When you post an updated
database, your users automatically get it installed on their machine the
next time they launch your program. They don't need to know the name of the
database. You manage all of that in one place and can change it at any time.
A runtime version lets you control the Access version launched for users not
on your network.
Total Access Startup 2010 supports both 32 and 64 bit versions of Microsoft
Access 2010 letting you control which version your application requires. It
also supports all legacy versions of Access. Learn more about the
new features and
try out the free trial
version.
  
Total Access Analyzer Product Review
Geoff Hollander of Northwest Database Services and the Portland Access
User Group wrote a review of our Total Access Analyzer product. He provides
a nice discussion of how it finds ways to improve his Access applications:
"I always thought that I was thorough about going through an
application and cleaning up loose ends, but Total Access Analyzer proved: I
was wrong and I probably won't call another application complete until Total
Access Analyzer gives it the OK."
He also suggests how the documentation it generates and its reports are a
business opportunity:
"Selling a documentation package generated by Total Access
Analyzer for your application is a great way to add a training-free,
trouble-free and reasonably priced profit center to the work you are already
performing!....Total Access Analyzer is a solid product that any Access
developer should have in their toolbox; and one that will pay for itself in
short order."
Complete review
Participating on the Senate Finance Committee's Small Business
Roundtable
 On
September 15th, FMS President Luke Chung was invited by the Senate Finance
Committee to share his experiences as a small business owner. As one of 18
participants, Luke was asked about his experience running FMS and how tax
policy can hurt and help small businesses thrive and create jobs. In a very
bipartisan environment, the staffers of co-chairmen Senator Max Baucus
(D-Montana) and Orrin Hatch (R-Utah) listened to the participants who
provided a perspective quite different from the deep pocketed lobbyists they
normally experience on Capitol Hill.
Read more about it in Luke's Blog:
Participating on the Senate Finance Committee's Small Business Roundtable
  
Total Visual CodeTools for Microsoft Access 2010 is Now Shipping
Discover why so many professional developers rely on
Total Visual CodeTools
to make them more productive.
Integrated directly into the Integrated
Development Environment (IDE),
Total Visual CodeTools offers a rich set of developer tools to help you create, cleanup, and
deliver better solutions. The latest version is enhanced for
MS Office/Access 2010 and has many new features.
Total Visual CodeTools supports all VB6/VBA hosts, including
Visual Basic 6.0 (VB6) and Office 2010, 2007, 2003, 2002/XP, and
2000.
Download the Free Preview of Total Visual CodeTools for Microsoft Office
Access 2010 (June 2011)
Download the free preview of
Total Visual CodeTools 2010
for Microsoft Office/Access 2010. The
Preview
Version is fully functional through the end of July. Take advantage of
this opportunity to see how Total Visual CodeTools can cleanup the code in
your existing projects, let you deliver more robust solutions, and simplify
your daily coding chores.
Integrated directly into the Integrated Development Environment (IDE),
Total Visual CodeTools
gives you a rich set of tools to help you create, cleanup, and deliver
better solutions. The latest version is enhanced for MS Office/Access 2010
and has many new features:
- Supports Microsoft Access/Office 2010, 32-bit version
- VBA Code Parsing Supports Access/Office 2010
- Code Cleanup and Code Delivery Allow Immediate Overwrite
- Code Cleanup Error Enabler and Handler Tags are Customizable
- Copy Control Builder Supports Multiple Target Controls
- Long Text/SQL Builder Supports Query Retrieval and Converts Tabs and
Spaces
- Select Case Builder Supports Text Blocks and Numeric Ranges
- Recordset Builder Defaults to Current Database and Simplifies
Selections
- Three Locations for Total Visual CodeTools on Your Menus
- Tools Available During Debugging
- Default 'Send To' is Remembered
- Screens are Resizable
- Redesigned Storage of Standards for Improved International Support
Visit these pages for:
Total Visual CodeTools supports all VB/VBA hosts, including Visual Basic
6.0 (VB6) and Office 2010, 2007, 2003, 2002/XP, and 2000.
 Photos
from the Portland Access User Group Conference
Check out the
photos from the three day
Microsoft Access conference sponsored by the Portland Oregon Access User
Group. FMS President Luke Chung spoke at the event and had a
delightful time in the hills of Silver Falls State Park.
Can't wait to attend next year's event!
Creating
a Backup and Disaster Recovery Plan for Your IT System
 Here's an article by FMS President Luke Chung that was recently
published on the
Entrepreneurs' Organization, Washington DC web site discussing the
need of small business owners to
Create a Backup and Disaster Recovery Plan for Your IT System.
Luke has been a member of EO for over a decade and previously served as
the Washington DC chapter president.
 The article covers our experiences working with people running small
to medium sized organizations, and the challenges they face to address
business process continuation issues. An overview of the basic steps are
covered.
Full Article
This is related to a recent article:
Creating a Backup and Disaster Recovery Plan for Microsoft Access
Database Applications
  Published Article: Microsoft Access Is Underrated: Your Hatred Of Microsoft Access Is
Largely Unjustified
 The
Enterprise Features web site highlight's FMS President Luke
Chung's discussion about why
Microsoft Access is underrated and hated in
large enterprise organizations.
He discusses the dynamics of IT departments in large organizations and
their natural conflict with the needs and budgets of information worker. He
also shows how organizations that understand the strengths and weaknesses of
Microsoft Access can leverage its power for competitive advantage, and how
to structure service levels to do so.
Luke
Chung Speaking at Portland Access User Group Conference in May 2011
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
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
  Total
Access Emailer for Microsoft Access 2010 is Now Shipping (March 2011)
Total
Access Emailer is the most popular Microsoft
Access email program. Running as an add-in,
it lets you easily send personalized emails
using the information in your database. From
using fields in the subject and body of the
message, to attaching PDF reports filtered for
each recipient, you'll find that Total Access
Emailer revolutionizes the way you communicate
with your contacts. Any table or query can be
the data source for your emails which can be
in text or HTML format. We can even automatically
include graphics in your HTML emails or let
them reference a public site.
We are very pleased to announce Total Access
Emailer for Access 2010. Enhancements include
support for Access 2010, 32 and 64 bit, compressing
all your attached files into one zip file with
optional password, international extended character
support, a new Code Generator, additional programmatic
interfaces, and
many more new features. An
X.6 upgrade version
for Access
2007 and earlier versions also available. Download the
Free Trial.
 New
Version of Sentinel Visualizer Released
Sentinel Visualizer is our commercial, off-the-shelf product that brings
the power of data visualization, link analysis, geospatial, timeline,
Social Network Analysis (SNA). We recently released version 4.6 which
includes many new features to empower analysts to better understand
hidden relationships in their data:
- Integration to Google Earth Version 6 to map entities
- Upgraded Declutter tool – filter by value of Degree, Entity
Weight, Entity Value, Relationship Weight, and Relationship Value
- Export subset of link charts into a new window to perform
additional analysis
- Send a selected network to a new visualizer window without
having to re-create the network
- Improved data-import routines including saving schemes for
reuse, avoiding duplication of imported data, and more import
options
Learn more about Sentinel
Visualizer built on SQL Server.
 Total
Access Admin for Microsoft Access 2010 is Now Shipping (Dec 2010)
Total Access Admin lets
you monitor your 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 Access 2010 and 2007. In
addition to supporting 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, and log the users entering and exiting each
database. Visit New Features for complete information. Total Access Admin 2003, version 11.5, is also released for Access
2003 and earlier.
Free Trial of Total
Access Admin
 Total
Access Statistics for Microsoft Access 2010 is Now Shipping (Sept 2010)
Total Access
Statistics is the most popular data analysis program for Microsoft
Access. It extends the power of Access queries to let you generate a
wide range of values such as
percentiles, regressions,
running totals,
correlations, group analysis, etc.
Total Access Statistics is now shipping for Microsoft Access 2010. In
addition to supporting the 32 and 64 bit versions of Microsoft Access
2010, version 14 offers new
financial cash flow analysis to generate net
present value (NPV), internal rate of return (IRR), modified IRR (MIRR)
for periodic and date dependent investments and receipts.
New Features
for Access 2010.
A new X.8
version is also available for Access 2007, 2003, 2002, and 2000.
This is free for customers under a support contract, and is available
for a nominal
upgrade fee for others.
Free Trial of
Total Access Statistics
FMS Papers Featured on the Microsoft Access Team Blog (August 21, 2010)
Our two papers on Microsoft Access, Windows Azure, and SQL Azure are
featured on the
Microsoft Access Product Development Team Blog
Microsoft
Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server
Tables in the Cloud)
FMS President Luke Chung has written a detailed paper on his
expectations of cloud computing and its revolutionary impact on our
industry. He considers it the most significant trend since the rise of the
Internet in the mid-1990's.
He's written two articles on this topic. The first is a general overview
of how he sees cloud computing impacting our industry:
The
second paper is an example of using SQL Azure with Microsoft Access
databases. While much of cloud computing and especially Microsoft Azure is
focused on the .NET community, there's much to offer to the Microsoft Access
community as well. Follow the detailed step-by-step instructions on linking
a Microsoft Access 2007 or 2010 database to tables stored in SQL Azure,
Microsoft's SQL Server in the cloud.
Then, think about how the ability to create and host
enterprise quality databases can impact what is possible for you.
Total Access Statistics 2010 Preview Version Extended (June 25, 2010)
 We've
updated and released a new version of the preview version of
Total Access Statistics
for Microsoft Access 2010. The original version expired on July 1, but this
version is good through September 1. We hope you get a chance to use it and
provide feedback on what you discover.
Total Access Statistics 2010 Preview Version Available (May 26, 2010)
We
are pleased to announce the availability of the preview version of
Total Access Statistics
for Microsoft Access 2010. 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).
This FREE preview is available with 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.
The preview version is fully functional through July 1. Download:
Total Access 2010
Preview Version
 Luke Chung Appointed to Fairfax County, Virginia's Information
Technology Policy Advisory Committee (May 25, 2010)
Approved by the Board of Supervisors, FMS president Luke Chung will
serve on the county's
Information
Technology Policy Advisory Committee (ITPAC) to advise the county's
board and CTO on the future direction of information technology
investments. Having served several years on a business and community
advisory committee for the superintendent of public schools, Luke is
representing the school board on this committee. "It's an honor to serve
on this board to help our county and it's 1,000,000+ residents maximize
the use of technology to improve services, safety, education, and good
governances while minimizing overall costs," said Luke Chung. "Over the
years, Fairfax County has established itself as a state and national
leader through solid business growth and high quality public education.
With constrained budgets, I expect we will continue that tradition through
the smart application of technology."
Total Access Admin 2010 Preview Version Available (April 16, 2010)
 We are pleased to release a FREE preview version of Total Access Admin 2010 for your review. Total Access Admin lets you monitor Access databases in real time. Select any Access Jet database (MDB or ACCDB) across your network to view and log users as they enter and exit your database. It's particularly useful for documenting suspect connections that could be the source of database corruption. You can also perform a variety of tasks such as locking new users from opening your database, compacting the database after everyone has exited, etc. The existing version supports Access 2007 and earlier. This new version support Access 2010 for both 32 and 64 bit formats, along with databases from earlier version of MS Access. For more information and download instructions, visit Total Access Admin 2010 Preview.
Total Zip Code Database Now Has Geospatial Latitude and Longitude
(April 2010)
 One of the nicest features to add to an address data entry screen is to automatically fill the city and state fields when a zip code is entered. In conjunction with the US Postal Service, FMS offers the Total Zip Code Database which gives you the entire list of valid zip codes and their corresponding city and state names. Both the primary and secondary city names are provided. Speed up data entry, eliminate typos, and clean up existing data with Total Zip Code Database. We also include the list of common city names the USPS doesn't like with their corresponding corrections. The database is provided on an annual subscription basis with an initial list and 11 monthly updates.
In addition to the information provided by the USPS, the Total Zip Code Database also includes geospatial coordinates (latitude and longitude) for each zip code. We also provide a list of countries and states to simplify lookups, and module code and sample form to add this to your applications. The data is provided in a Microsoft Access MDB and ASCII files.
For more information, visit the Total Zip Code Database page, view the zip code flier, or get the demo.
 New
Updates for Total Access Detective (January 22, 2010)
Total
Access Detective makes it easy to find differences
between any two Microsoft Access databases or objects.
As part of our commitment to quality, we are pleased to release
updates of Total Access
Detective for our versions for Microsoft Access 2007, 2003, 2003,
and 2000.
The updates include performance enhancements, Windows 7 support,
improved ADP support, and resolve all known issues since their original
release. The updates are available free of charge to registered owners who
were emailed download instructions for the update. Please contact us if
you are a registered owner and did not receive a notification.
Calculating Percentiles in Microsoft Access with Total Access
Statistics (January 2010)
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 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
Total Access Emailer
Programmatic Interface (January 2010)
 Total Access Emailer is the world's leading
email program for Microsoft
Access. It runs as an Access add-in to let you easily create email
blasts using your list of email addresses and integrating your data and
reports into your messages and attachments. The Professional Version
includes a programmatic interface that lets you automate the sending of
email blasts through your VBA module code. A simple procedure is
provided to let you launch an email blast.
Here's a new page describing how to
Send Microsoft
Access Email Blasts Programmatically using VBA.
 Total
Visual SourceBook 2007 Ships for Microsoft Access/Office 2007
Total Visual SourceBook
is the most extensive professional source code library for Microsoft
Access®, Office, and Visual Basic 6.0. The latest version
includes full support for Access/Office 2007 including the new
Access 2007 ACCDB database, Outlook 2007, and many
new features
to expand the considerable source code library. There are now 194
classes/modules, 100,000+ lines of code, and almost 20,000 lines of
example code.
As before, you have full
control: use our code, learn from it, and enhance it.
Best of all, the code is provided royalty free so you can use it in
your projects immediately! Written by our staff
of Microsoft MVP's, much of this code can't be found anywhere else!
 Luke
Chung Speaking at Office DevCon 2009
October 31 - November 1, 2009
Brisbane, Australia
FMS President
Luke Chung will be giving several presentations on
Microsoft Access application development and our
products at this conference. Hosted at the University of Queensland, St. Lucia
campus, we hope you see him down under!
Two More FMS Articles are published on MSDN
(October 2009)
 FMS is honored that Microsoft published
two more of our popular articles on their MSDN global site:
We recently enhanced the query paper to include additional information
on the
Update Query syntax.
New Look and Feel for Our Web Site
(September 2009)
Our web site is undergoing major renovations and sports a new look
and feel. While portions are still undergoing changes, much of the work
is completed and published. We hope you like the enhancements with more
improvements to come!
Total
Access Detective Versions X.7 Ship for Microsoft Access 2003, 2002, and
2000 (August 2009)
Total
Access Detective makes it easy to find differences
between any two Microsoft Access databases or objects.
With the recently release of the Access 2007 version, we're pleased
to provide new versions for Microsoft Access 2003, 2002, and 2000
(versions 11.7, 10.7 and 9.7 respectively). Version X.7 adds many
new features including data comparison between two queries, enhanced
data comparison options such are comparing two tables when field names
are not identical (compare only identical field names or on field
order), using the first field as the key field if no key field exists,
skipping small numerical data differences, ignoring case differences
between modules, improved support for ADP comparisons, etc. Existing
customers can upgrade for a nominal fee.
Existing Total Access Detective customers under annual support
contracts receive the upgrade for free.
FMS Article on Error Handling in VBA/VB6 is published on MSDN
(August 2009)
FMS is honored that Microsoft has published one of our popular
articles on their MSDN global site. Originally published as one of our technical papers on our web site (Error
Handling and Debugging Tips and Techniques for Microsoft Access, VBA,
and Visual Basic 6 (VB6), Microsoft has now added our paper to their
MSDN site. Check it out
here.
Free Update for Total Access Statistics 2007 and Total
Access Admin 2007 (August 2009)
As part of our commitment to quality software, FMS
periodically releases updates patches to add new enhancements and
resolve known issues. We've released updates for these products:
 Total Access Statistics is the most powerful data analysis program
for Microsoft Access. Extend the power of Access queries with advanced
analysis such as percentiles, frequency distributions, moving averages,
t-Tests, confidence intervals, ANOVA, data normalization, and much
more. Version
12.00.0009 is now available for Access 2007 and includes improved
support for ADPs and certain calculations.
Total Access
Admin 2007 lets you monitor multi-user entries and exits to your
Access databases in real-time. Watch and log the activity and catch
suspect connections or drops that can cause database corruption. It can
even compact your database after everyone has exited. This patch
addresses some of the issues associated with supporting password
protected databases and databases under workgroup security. (Version
12.00.0140)
These updates are available free of charge to registered
owners of Total Access Statistics 2007, version 12.0 and Total Access
Admin 2007. Notification and download instructions for receiving the
patch were emailed to registered owners. If you did not receive
instructions, please
contact us
so we can update your information.
Total Access Detective Ships for Microsoft Access 2007 (July 2009)
Total
Access Detective makes it easy to find differences
between any two Microsoft Access databases or objects.
Know exactly what changed with your properties, fields,
indexes, controls, sections, macro lines, VBA module
code, and data! List objects in one database and not the
other. Find new, deleted, and modified records. Combine
records from two tables into a new one.
New features include support for Access 2007 and the
new ACCDB database format including multi-value fields,
enhanced data comparison options, improved support for
ADP comparisons, and much more!
Total Visual Agent Ships with Full Support for Access 2007 (July 2009)
 Microsoft Access databases need to be periodically
compacted for optimal performance. You should also
perform regular backups.
Total Visual
Agent performs these system administrative chores,
and automates a wide range of Access tasks such as
running macros on a schedule. Everything is audited with
email notification of problems. Now with full support
for Access 2007 and the new ACCDB database format.
Microsoft SQL Server Development Services
 When we develop custom database applications on the desktop
or web, we often store the data in Microsoft SQL Server.
Contact our Professional Solutions Group for help with your
database development efforts. Whether it's migrating an
Access database from Jet to SQL Server or creating a highly
scalable web solution using ASP.NET, our team of database
experts are here to help. Learn more about our
Microsoft
SQL Server consulting services.
Update of Total Access Admin 2007 (June 26, 2009)
Total
Access Admin offers a real-time
monitoring of users entering and exiting any Microsoft Access database
across your network. An update of Total Access Admin 2007 was just
released. All customers were notified of the
update via email with download
instructions.
Microsoft ASP.NET Website Development Services
FMS is well known for our world class Microsoft Access and desktop
development skills. Did you also know our Professional Solutions Group
is very experienced creating database driven web solutions
using Microsoft ASP.NET and SQL Server?
We recently updated our information on our
Microsoft ASP.NET website development services.
Luke Chung Speaking at the Washington DC Access User Group
FMS President Luke Chung is the guest speaker at the June 17th
meeting from 7 to 9 PM. Luke will
be speaking on "Cool Features in Access 2007" and any other topics the
audience raises. The event is free and located at the Washington DC Veterans Affairs Medical Center
in Washington DC. For more information, visit the
Washington DC Access SIG web site
Online Video from the Microsoft TechEd Conference
Watch videos of Luke Chung's participation on the Microsoft Tech Ed
Conference panels.
Luke Chung Speaking at Microsoft TechEd Conference
Microsoft has invited FMS President Luke Chung to participate on three
panel discussions at their annual conference from May 11-15th in Los
Angeles. Luke will be covering:
- Running a Software Consulting Business
- Developing SQL Server Applications
- Development Strategies During These Challenging Times
For more information, visit
our Upcoming Events page. Hope to see you there!
Total Access Components 2007 Ships
 Total
Access Components 2007 lets you enhance your applications with amazing visual effects, interactive
features, and other features that are sure to amaze your
users. Add powerful
functionality to your Access application in minutes with the only
collection of ActiveX custom controls designed specifically for
Microsoft Access.
New features
include support for Access 2007, a new Cursor control,
and enhancements to many controls.
Free demo available.
Luke Chung Speaking at the Denver Access User Group
Luke Chung is the featured speaker at the March 19th Denver Access
User Group meeting held at the Microsoft Office in downtown Denver from
6 to 9 PM. He'll be covering Microsoft Access 2007, the FMS products for
Access, and entertain any questions that may arise. The event is free
and we encourage you to become member of the group if you aren't
already.
For more information, visit
http://www.daaug.org/
(Blog)
 MSDN Channel 9 TV - Luke Chung on Microsoft Access Database and Migration Challenges
Microsoft's Dr. Zhiming Xue interviews Luke Chung on topic of dealing with Access
database solutions and challenges that project teams deal with
when migrating them to more scalable solutions.
Watch the
video (22 minutes) and read more about
Migrating
Microsoft Access Databases to SQL Server. (Blog))
 FMS
is Serving the United States State Department
FMS is honored to provide custom application design and development
work for the headquarters of the US State Department in Washington, DC.
The State Department is using our ASP.NET
development and SQL Server database expertise to enhance one of
their existing public web site which is being converted from legacy
ColdFusion and Delphi technologies.
Total Access Analyzer Version X.8 for Microsoft Access 2003, 2002,
and 2000 is Shipping (January 2009)
 An
updated version of Total Access Analyzer
is now shipping for Access 2003, 2002, and 2000. Many new features were
added to help you find more ways to improve your Access databases. Here
are the new
features. Customers on support contracts receive the upgrade
automatically, other customers can upgrade for a nominal fee.
Excel Security Patch Conflicts with Pasting Data into Access Tables (December 2008)
If you're used to pasting Excel spreadsheet data into an Access
table, you may have encountered this error recently:
The data on the Clipboard is damaged, so Microsoft Office Access can't
paste it. Maybe you thought there was something wrong with your
spreadsheet, data, or memory. It turns out this is caused by a Microsoft
Excel 2007 security patch that was released December 9th. Learn about
the issue and a few workarounds.
 The Hot Mommas Project:
FMS Creates a Social Networking Website for Female Entrepreneurs (December 2008)
Seeking to build the world's leading case study site for
businesswomen and entrepreneurs, a professor at the George
Washington University Business School chose FMS to get it
done. Key Features include:
-
 Social networking features including tagging and public profiles
- Rich text authoring
- Search Engine Optimization (SEO) driven URLs for participants' cases
- Great prizes for competition winners!
Read more about this
social networking website.
White Paper: Application Development During Uncertain Times (November 2008)
Read FMS president Luke Chung's
white paper on how to best develop applications and
position yourself during these challenging economic times.
Balancing budgets, application requirements, and the rapidly
changing external environment, a strategy that's quick and
nimble is in more demand than ever. Learn how to best
position yourself and your organization in these challenging
times. Minimize risk and maximize your potential by getting
solutions into production quickly and letting the market
decide what survives and dies. Application evolution and
natural selection is most powerful during times like these.
Make sure you anticipate those forces.
Streamlining the Harvard College Interview Process (November 2008)
 It's
the season for high school seniors to apply to college. This
year our Professional Solutions
Group is helping
Harvard
College automate their interview process. Almost every
student who applies to be a freshman is offered a personal
interview with a local Harvard alum. With over 22,000
applicants last year, it's quite a challenge to match up
applicants with interviewers, and manage all the paperwork.
Our Professional Solutions Group created a web based
solution using SQL Server, Visual Studio .NET, and an Access
administrative interface to assist with the process. With
Harvard now providing massive scholarships based on
financial need (families making under $80K a year don't have
to pay anything and those making up to $200K pay only 10%),
we expect an even larger pool of applicants. Best wishes to
all who apply!
Total Access Speller 2007 Ships (October 2008)
The Microsoft Access 2007 version of
Total
Access Speller is now shipping with many
new features.
New X.5 versions are also available for Access 2003, 2002, and 2000.
Total Access Analyzer 2007 Ships (October 2008)
Thank
you for your patience! The much awaited Microsoft Access 2007 version of
Total Access Analyzer is now shipping.
Total Access Memo 2007 Ships (August 2008)
Total Access Memo 2007
for Microsoft Access 2007 is now shipping with full
support for Access 2007 through Access 2000. Easily add
rich text memo fields to your forms and reports tied to
your tables. Includes a built-in full screen text editor
to let you easily add fonts, point sizes, styles,
paragraph settings, graphics, hyperlinks, and more! You
can even spell check your formatted text with support
for 20 languages.
Free Seminar for Microsoft Access to SQL Server Upsizing Co-Sponsored by Microsoft on June 27, 2008 (Reston, Virginia)
Please join us for a half-day seminar on upsizing Access applications to SQL Server.
Luke Chung, FMS President, and Steve Clark, FMS Project Manager and
Microsoft MVP, will present these topics:
- Where Microsoft Access Fits in the Overall Database Strategy of an Organization
- Approaches to Upsizing Access to SQL Server
Microsoft Access to SQL Server Upsizing Seminar
Microsoft TechEd Panel Discussion: Are we there yet? Successfully
navigating the bumpy road from Access to SQL Server (June 18, 2008)
Watch the televised video of Luke Chung, FMS President, on a panel
discussion at the 2008 Microsoft TechEd Conference in Orlando, Florida.
Hosted by Microsoft's Mary Chipman, the panel discusses the
challenges and approaches of migrating Microsoft Access applications to
SQL Server.
Microsoft Access to SQL
Server Upsizing video
Total Visual CodeTools 2007 Ships (May 13, 2008)
 Total Visual CodeTools 2007 helps you write, cleanup, and
deliver better VB6 and VBA code. Discover why so many
Access, Office and VB6 developers rely on Total Visual
CodeTools to simplify their application development, fix
existing and inherited projects, and deliver more robust
and supportable solutions.
New features
include support for Access 2007, detecting unused
variables, improved code builders and utilities, and
much more.
Free demo available.
 Special Offer for Microsoft MSDN Premium Subscriptions (May 2008)
FMS
is pleased to provide a two year MSDN Premium
Subscription for almost the same price as a one
year subscription. If you're serious about
developing applications on the Microsoft
platform, you need to get this amazing resource!
Available while supplies last.
Details...
Total Access Startup 2007 Ships (March 13, 2008)
 Total
Access Startup 2007 is now shipping. Discover how Total Access
Startup ensures your users run the latest version of your database with
the correct version of Microsoft Access. Centrally manage an unlimited
number of Access databases across your network and simplify upgrades
between versions.
New features
include support for Access 2007, launching ADPs, supporting multiple
Access versions on the same database, and much more.
Press Release.
See you in San Diego, CA (March 2008)
Luke Chung is speaking at the March 19th meeting of the San Diego
Access User Group from 6-8PM.
FMS is exhibiting at the Microsoft booth at the DoDIIS conference
March 16-19th, so stop by if you're there.
For details, visit our
Upcoming Events page..
Total Access Admin 2007 Ships (Feb 5, 2008)
Total Access Admin 2007
is now shipping. Discover how Total Access Admin lets you monitor any
Access database (Access 97 through 2007) to see all the current user
connections. Watch how and when they enter and exit your database in
real-time, keep a log file, and troubleshoot problems. You can even set
it to compact the database once everyone exits.
Microsoft Access Help and Resource Center
Due to our extensive resources for Microsoft Access, a centralized
page was created to make it easy to find all the information:
Microsoft Access Help and Resources
It includes a brief history of Access, our experiences with Access,
links to technical papers, tips, and other resources. New items include
 Free
Book Offer for Microsoft Access 2007
Get this Access 2007 book, a $24.99 value, for free! Through special
arrangements with Zac Woodall and his book publisher, we're pleased to
offer a limited quantity of his book, The Rational Guide To Microsoft
Office Access 2007 Templates, with the purchase of one of our Microsoft
Access 2007 products.
Details...
New Technical Paper for Creating Monthly Summary Reports in Access
Written by Luke Chung, learn how to create spreadsheet like reports
with monthly summary columns without writing any code.
Details...
New Product: Sentinel Visualizer is Shipping (September 5, 2007)
Sentinel
Visualizer revolutionizes data analysis with a powerful combination
of features to let you maximize the understanding of your data. Gain
insight into multi-level relationships and complex networks. Apply link
charts, data filtering, gradient metrics, geospatial maps, timelines,
social network analysis, and much more.
Press Release
FMS Participating and Speaking at Advisor Summit in Miami, FL
FMS President Luke Chung is speaking in the Microsoft Access track of
this event. We will also have a booth among the exhibitors.
Details...
FMS Product Announcements for Microsoft Access 2007
We've been working with Access 2007 for over a year since the alpha
version was released and are delighted by the considerable investment
Microsoft made to enhance Access.
Rather than simply porting our products to
Access 2007 with the same functionality as before, we've invested the
time and effort to make sure we take advantage of the new capabilities
of Access 2007, added features requested by our customers, and applied
the new Office/Access 2007 look and feel.
Here's a summary of our plans
and schedule
Total Access Statistics 2007 is Shipping (July 20, 2007)
 Total Access Statistics for
Access 2007 is now shipping with many new features. Enhancements for
users of Access 2000, 2002, and 2003 is also available in a new
X.7 Version.
Additionally, the Total Access Statistics web site is updated with
information on the new versions,
product PDF fact sheet, new tour, etc.
Total Access Emailer 2007 is Shipping (May 18, 2007)
FMS is pleased to release our first product for Microsoft Office Access 2007.
Total Access
Emailer 2007 is now shipping and introduces several exciting
enhancements over the original release, including support for the new
ACCDB database format, new field types, new user interface, and the
ability to attach Access reports as PDF or XPS files to your emails.
 GSA Schedule Contract Awarded to FMS (April 16, 2007)
FMS
receives a General Services Administration (GSA) Schedule Contract to
provide software products and consulting services to the US Federal
Government.
 Microsoft Gold Certification for 5th Consecutive Year
Microsoft designates FMS as a Microsoft Gold Certified Partner for the 5th year in
a row. This is Microsoft’s highest partner certification level and
reflects the proven experience and expertise of FMS for creating
solutions using Microsoft technology.
Read on...
Protecting our Children with the National Center For Missing and
Exploited Children (Feb 07)
We recently began working with the good people at the National Center
for Missing and Exploited Children (www.ncmec.org)
to see how we could help their efforts. We also learned a lot about how
to better protect our children.
Read on...
FMS Free Links to Outside Resources (Feb 07)
Can't find what you're looking for on Microsoft Access, .NET, SQL
Server? Visit our newly updated
free links page
and utilize the list of outside resources we've put together for your
convenience.
Microsoft Featured White Paper, by Luke Chung, Updated (Jan 07)
In an effort to keep you, our customer, up with the latest advances
in the industry, we have again updated one of the key white papers
regarding Microsoft Access.
Learn when to use Microsoft
Access and when to use SQL Server in your organization. This newly
updated white paper discusses database needs, evolution, and challenges,
the advantages, limitations, and myths of Access, and how to use Access
and SQL Server strategically in your organization.
News Archive
|
Email Newsletter
Facebook
Twitter
