FMS News Archive
This is what a government shutdown looks like to contractors. We have a small project with Amtrak to support a Microsoft Access application. They sent us this letter after the budget impasse in Congress.
The suspension isn’t a big deal to us since we don’t have dedicated staff supporting it. It’s awful for contractors with larger commitments and their staff who are unlikely to be compensated for the shutdown.
After posting on Twitter about the letter we received from Amtrak in regard to the Government Shutdown, FMS President Luke Chung was contacted by WUSA9 and the Huffingtonpost.
WUSA9, December 26, 2018
On December 26, 2018, FMS President Luke Chung was quoted by John Henry from WUSA9 on our FMS, Inc. government contract suspension in his #ShutdownStories. It was featured on the 11pm News and WUSA9 website!
To read the article and watch the video, visit #ShutdownStories: Government contractors tackle life without pay during partial shutdown.
Huffingtonpost, December 27, 2018
On December 27, 2018, The Huffingtonpost quoted FMS President Luke Chung:
“Business owners who have [dedicated] staff are making the decision: Do we pay people or not, even though we won’t get paid by the government?” Chung said. “Either you force people to take vacation, or you pay them, to be a good company ― but depending how long it drags on, one may not have a choice.”
For the full article, visit Shutdown Leaves Government Contractors Without Work And Likely No Back Pay.
To read more on the Government Shutdown, visit our blog post, Government Shutdown's impact on the Contractors and Employees and
leave us a comment about your experience.
December 19, 2018
FMS President Luke Chung wrote a new paper on eliminating the default database security holes with Microsoft SQL Server on Azure.
Do not allow all Azure resources permission to your Azure SQL Server databases. Set the permissions to OFF to disallow all Azure services to connect to your SQL server:
Step-by-step instructions are provided to allow specific IP Addresses or range of IP Addresses that are permitted to get data from your server and databases.
Visit our page Microsoft Azure Security Holes with SQL Server Databases for more information.
Our December newsletter is now available!
If you did not receive the newsletter through email, you will find it here:
December 2018
Total Access Analyzer examines all your database objects to provide extensive documentation, code analysis, object cross-reference, and diagrams with over 390 presentation-quality reports. It detects 300+ types of errors, suggestions, and performance tips, so you can learn and apply Best Practices to fix problems, improve your design, and speed up your Access applications.
Enhancements
- Supports Microsoft Access 2019, 32-bit and 64-bit versions.
- Document All Database types supported by Microsoft Access 2019.
- Improved Blueprint Documentation.
- Additional Cross-Reference and Validation including Subform References.
Improved Memory Management.- Data Macro Documentation.
- Document Workgroup Security in ACCDBs.
- Better Support of Documentation for Multiple Databases.
- Module Bracket Reports.
- Improved User Interface Shows more Progress Details.
- New Manual and Context Sensitive Help.
- and more...
Existing Total Access Analyzer owners are able to upgrade at a discounted price.
December 2018
New updates for Total Access Analyzer are available for Microsoft Access 2016, 2013, 2010 and 2007. Total Access Analyzer is the most popular Microsoft Access add-in, that offers comprehensive documentation and analysis of your MS Access databases so you can better understand individual objects, cross-references between objects, procedure and data flow diagrams, VBA module analysis, and much more. Detecting over 300+ ways to fix and improve your databases, Total Access Analyzer improves the quality of your work, teaches you best practices, and increases your productivity.
Enhancements
- Additional Cross-Reference and validation of tables, queries, fields and controls across your database objects, including references in subforms.
- Improved form and report blueprint documentation to capture large and complicated designs and layouts.
- Improved memory management for documenting large Access databases to minimize the chance of running out of memory.
- Data macro documentation and cross references to related tables.
- Documentation of workgroup security settings for ACCDBs if they were converted from MDBs with workgroup security.
- Improved user interface to show progress of the documentation.
- Revised user manual and help file.
- and more...
For more information, visit:
- Total Access Analyzer 2016 Build: 16.10.0040
- Total Access Analyzer 2013 Build: 15.60.0040
- Total Access Analyzer 2010 Build: 14.60.0040
- Total Access Analyzer 2007 Build: 12.96.0040
Download the Free Trial to experience it for yourself.
October 10, 2018
FMS, Inc is celebrating its 32nd year! Since we started in 1986, FMS has become the world's leading developer of products for Microsoft Access developers and a top vendor of products for the SQL Server, Visual Studio .NET, and Visual Basic communities.
With tens of thousands of customers in over 100 countries, FMS customers are comprised of a variety of organizations from small to large including 90 of the Fortune 100 and every US federal government department. Our experience and processes for developing commercial off-the-shelf software deployed worldwide is applied throughout all our development efforts.
We at FMS, Inc. want to thank our customers for choosing us and we hope we can continue serving you in the future.
Do you only have the ACCDE or MDE database files but can't find the original ACCDB and MDB files that created them?
We provide a database recovery service to convert ACCDE and MDE databases to ACCDB and MDB files. Also, we rescue data and other objects from a corrupt Access database.
We need to perform an assessment of a few hours to see if a recovery is possible, and if so provide the cost for doing it. This service is only provided if you have ownership of the solution and intellectual property.
For more information, visit Microsoft Access Database Recovery Service.
October 9, 2018
Many Microsoft Access users have recently been confronted with this error when they open their database on Windows 10 machines:
"Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During this process, a backup copy of the database will be made and all recovered objects will be placed in a new database. Access will then open the new database. The names of objects that were not successfully recovered will be logged in the 'Recovery Errors' table."
We wrote a blog post on a potential workaround for this error. Please share your experiences!
October 4, 2018
FMS President Luke Chung met with Emanuel Gonzalez-Revilla the Ambassador of the Republic of Panama to the United States.
They had a nice candid discussion about the business climate in Panama, the work he did there before becoming ambassador, his role as US ambassador, relations between the US and Panama, relations between Panama and other countries, especially China, banking Panama and the Panama Papers scandal, raising his two college age sons, and what he may do after his 5 year term expires next year.
For more information on Ambassador Emanuel Gonzalez-Revilla, visit the Embassy of Panama.
September 19, 2018
7:00PM - 9:00PM
Microsoft Store in Tysons Corner Center
Join FMS President Luke Chung on September 19, 2018, at the Washington, DC Access User's Quarterly Group meeting at the Microsoft Store in Tysons Corner Center.
Tammy Lawson will be giving a presentation on Integrating Microsoft Access with PowerBI to create visualizations.
For more information, visit Washington, DC Microsoft Access Meetup.
Microsoft recognized FMS President Luke Chung as a Microsoft MVP for the seventh year in a row for his support in the Microsoft Access community!
The Microsoft Most Valuable Professional (MVP) award is given to individuals who have exhibited exceptional technical expertise and a talent for sharing knowledge within their technical community.
Our August newsletter is now available!
If you did not receive the newsletter through email, you will find it here:
August 21, 2018
Total Access Emailer is the most popular email automation system for Microsoft Access. A new update was released for the Microsoft Access 2016 version.
Enhancements
- Partially Restored Original SMTP Validation Technique.
- Validation of FROM Address during Email Blasts.
- Adjusted the saving of datasheet column settings on databases before Access 2007.
- Improved Offline activation and uninstall.
- Cosmetic changes to the program and sample databases.
For more information, visit:
- Access 2016 Build: 16.01.0016
Existing Total Access Emailer 2016 owners were notified to download the update.
July 19, 2018
President Lincoln's Cottage, Washington, DC
FMS President Luke Chung was honored to meet David Rubenstein, philanthropist and co-founder of the Carlyle Group during the Washington DC Chapter of the Entrepreneurs Organization event.
The event was held at President Lincoln’s Cottage in Washington, DC, where Lincoln summered and drafted the Emancipation Proclamation, two copies of which David purchased and donated. David Rubenstein is a fascinating and inspirational leader who has helped many companies around the world, and is dedicated to a legacy of preserving historic documents and sites, and pandas.
Our July newsletter is now available!
If you did not receive the newsletter through email, you will find it here:
July 18, 2018
7:00PM - 9:00PM
Microsoft Store in Tysons Corner Center
Join FMS President Luke Chung on July 18, 2018, at the Washington, DC Access 2nd Quarter User's Group meeting at the Microsoft Store in Tysons Corner Center.
Members will share their experiences with Microsoft Access and the solutions to different Microsoft Access questions.
For more information, visit Washington, DC Microsoft Access Meetup.
July 1, 2018
Microsoft has officially recognized FMS President Luke Chung as a Microsoft MVP for the seventh year in a row!
Visit Microsoft's MVP Public Profile Page to learn more about Luke's contributions to the Microsoft Access Community.
Congratulations Luke!
June 19, 2018
Total Access Emailer is the most popular email automation system for Microsoft Access. A new update was released for the Microsoft Access 2016 version.
Enhancements
- SMTP validation uses your email address and eliminates the need to use a TEmail.txt file.
- Changes you make in the datasheets settings such as column settings, sort order, and/or filters are saved where appropriate for the next time the form is opened.
- Preview Text allows you to test your email blasts by sending the emails to your own email address.
- When setting an email blast, the FROM email address is validated for an acceptable email format.
- When the name of an attachment file includes invalid characters (e.g. :*?"<>|), a message indicates that problem rather than saying the file can't be found.
- Procedure TotalAccessEmailer_SendOne had two parameters (strMessageHTML and strHTMLFile) that are optional but were previously required.
- Sample database updated with TLS option and larger fonts.
- Cosmetic changes to increase font size, widen combo boxes, font consistency, and support for higher resolution monitors.
- Manual and help file updated.
For more information, visit:
- Access 2016 Build: 16.01.0014
Existing Total Access Emailer 2016 owners were notified to download the update.
May 18, 2018
Total Access Detective finds differences between Microsoft Access databases and objects. Updates for Total Access Detective are available for Microsoft Access 2016, 2013, 2010 and 2007.
Enhancements
- Improved SQL string comparisons for saved queries and properties like RecordSource and RowSource.
- Trailing blank spaces and extra blank lines are removed before comparing them, this avoids flagging SQL string differences that do not affect functionality.
- Query comparison. Under Data Options, if the query option is set to First Field Unique, it was always treating them sequentially and stopped on the first difference. This is fixed and works correctly.
- Table macro comparison supports table names with apostrophe (') in the them.
- Text comparison. If the VBA option is not selected, the results do not show the Procedure tabs.
- Database comparison results: The database name goes across the entire top of the form rather than being truncated.
- All other reported issues.
For more information, visit:
- Access 2016 Build: 16.01.0024
- Access 2013 Build: 15.51.0024
- Access 2010 Build: 14.51.0024
- Access 2007 Build: 12.91.0024
Existing Total Access Detective owners were notified to download the update.
Our May newsletter is now available!
If you did not receive the newsletter through email, you will find it here:
May 11, 2018
Remote Desktops connections are failing to connect due to a security patch that was released on May 8, 2018.
An authentication error has occurred. The function requested is not supported Remote computer: [computer name] This could be due to CredSSP encryption oracle remediation. For more information, see https:/go.microsoft.com/fwlink/?linkid=866660
It's also impacting VPN connections.
We wrote a blog post on the issue, symptoms, causes, and workaround. This is a brand new situation. Please share your experiences.
FMS President Luke Chung wrote step by step instructions on how to convert existing databases to an Elastic Pool.
Microsoft provides information on Elastic Pools but does not give you information on how to convert existing databases to those Elastic Pools.
Visit our page Converting Microsoft Azure SQL Server Databases to SQL Elastic Pools to Share Server Resources for more information.
April 28 - 30, 2018, Silver Falls State Park, Oregon
The Portland Access User Group held their annual event at the conference center in the beautiful Silver Falls State Park a few hours south of Portland, Oregon. The weekend event brought together some of the top Microsoft Access developers, enthusiasts, and Access development team members.
FMS President Luke Chung was one of the featured speakers. He made two presentations:
- Data Analytics: Query Tips and VBA Code
- Form and Report Design Tips and Techniques
Our April newsletter is now available!
If you did not receive the newsletter through email, you will find it here:
FMS President Luke Chung wrote a new paper on monitoring SQL server usage and setting DTU Limits with Microsoft Azure.
Why does the 60 minutes graph look so different from the 65 minutes graph?
60 Minute Graph
65 Minute Graph
To learn why, visit: Monitoring SQL Server Usage on Microsoft Azure and Setting DTU Limits
April 7-8, 2018, Hotel Strudlhof
FMS was a sponsor for the second Microsoft Access Developer Conference in Vienna, Austria.
Fellow Microsoft Access MVP Karl Donaubauer hosted a sold-out event with 60 attendees from 13 countries. Photos from the 2018 event are available here.
FMS President Luke Chung was a featured speaker for the 2018 conference and gave a new presentation on Incompatibilities Among Microsoft Access Versions
For more information: Access DevCon Vienna
April 11, 2018
The Facebook security breech is actually a violation of Facebook API licensing rules. Facebook provided the data so developers like us could create innovative solutions. They weren't selling the data.
One of the things developers couldn't do was to save the data. That's how the data improperly got to Cambridge Analytica. All of that was shut down shortly when Facebook limited their APIs and prevented our application from getting to the data. It's not entirely Facebook's fault for trying to spur innovation by sharing their data for free. Unfortunately, some developers violated their terms completely.
Here’s a new web page describing our experience in more detail: Facebook Application with Social Network Analysis (SNA) and Geospatial Mapping
For more information, visit our blog post:
What happened when we created a Facebook App for Social Network Analysis
March 20, 2018
FMS President Luke Chung had the pleasure to attend a meeting with Linda McMahon the SBA Administrator. Linda McMahon spoke about the Small Business Administration that she currently leads, how they help businesses around the country, and her journey from a small town in NC to running the WWF, now WWE, in an obviously male dominated industry.
Here's a list of free resources directly from the Microsoft Access team. It includes the new technical community, training videos, help center, blog, and how to sign up to be an Office Insider.
Visit our blog post for more details.
Our March newsletter is now available!
If you did not receive the newsletter through email, you will find it here:
FMS President Luke Chung
gave a presentation on Microsoft Access Form Tips and Techniques to a group of Access enthusiasts at Access Day in Redmond, Washington.
Celebrating Microsoft Access
with fellow Access MVPs at the annual Microsoft MVP Summit. Pleased to learn of the new features coming to the Access Desktop in Office 2019,
and the positive direction the Access development team is taking.
March 14, 2018, Towson University
2018 Microsoft MVP Tech Tour at Towson University.
FMS President Luke Chung is a speaker and will
- Present Cloud Technology: Office Desktop (Access/Excel) to SQL Server to the Azure Cloud
- Participate on a Career Panel Discussion
Microsoft Access debuted in 1992 and recently celebrated its 25th Anniversary! Over the decades, Microsoft Access evolved with a large number of enhancements, database formats, and discontinued features.
It's hard to remember all the changes. Fortunately, we created a page that shows the different Microsoft Access versions and changes in an easy to understand comparison matrix. See when versions were released, their latest service packs, database formats, linked tables, field types, security features, Windows Operating Systems, and many other features both new and old.
March 8, 2018, Redmond, Washington
Join us for Access Day, the one-day event with a variety of expert speakers and topics.
FMS President Luke Chung is a presenter and will be discussing Microsoft Access Form Tips and Techniques.
For more information and registration, visit: 2018 Access Day
February 2, 2018
We’ve updated our list of Microsoft Access updates and patches to includes Microsoft’s recent releases for MS Access 2016 and 2013.
It also includes information on the three different update channels for Office 365 and how that compares to the perpetual Office/Access license.
Links to the Microsoft KnowledgeBase articles and download files are included.
The Sean Hannity Radio Show, January 22, 2018
Background
On January 22, 2018, Luke Chung was on the radio show with Sean Hannity and Andrew Ziem. The three of them discussed the technology behind the ability to retrieve text messages that were deleted. Luke commented specifically on:
- How text messages are stored on a sender’s/receiver’s device, unlike emails which are stored on a central server.
- The ability to retrieve an email that has been deleted is more likely than trying to retrieve a text.
To
listen to the interview and more insight on these issues, visit Luke Chung's blog post:
Sean Hannity Radio Show Interview on Missing FBI Text Messages
January 2, 2018
New versions of Total Access Statistics are available for Microsoft Access 2016, 2013, 2010, 2007, and 2003.
Enhancements:
- Adjusted treatment of null values as missing values rather than zero
- Updated digital signature for Runtime MDE (for MDB databases)
- Enlarged the field selection forms
For more information, visit:
- Access 2016 Build: 16.01.0031
- Access 2013 Build: 15.01.0031
- Access 2010 Build: 14.11.0031
- Access 2007 Build: 12.91.0031
- Access 2003 Build: 11.91.0031
Existing Total Access Statistics owners were notified to download the update.
Total Access Emailer is a Microsoft
Access program that lets you send personalized emails with attachments from your tables and reports to everyone on your list.
The Professional Version includes the Access add-in and a VBA Library so you can launch email blasts from VBA code and events.
We've created a new support page to help troubleshoot common issues when using the VBA interface.
- Make sure your copy of Total Access Emailer supports your Access version.
- If you upgrade your database from an MDB to ACCDB format, be sure to also update your Total Access Emailer library reference from our MDE to ACCDE library file.
Microsoft Access is celebrating its 25th year. It's an amazing accomplishment for a software product to be so successful for so many years.
We at FMS were there since the beginning.
Read our first hand, historical account of watching Microsoft Access take over the Windows desktop database market, and how we became the world's leading 3rd party developer of Microsoft Access products. Discover how we watched MS Access rise from nothing to the leading Windows desktop database application. This directly caused the implosion of Borland International which previously dominated the desktop database industry. Witnessing this in person was an amazing experience of how quickly technology can change established businesses.
This article was originally published by Microsoft on their website for the 10 Year Anniversary Celebration of Access (October 2002)
The video is from the November 1992 COMDEX conference where a very young Bill Gates personally announced the debut of Microsoft Access. He remains a big fan of Access and was actively involved in its design and development.
Read our new paper on how to easily convert a field's text to Proper Case (or ALL CAPITALS or all lower case). This can be done with a Microsoft Access query without having to write any VBA code.
By using VBA StrConv function in an Update Query, one can convert the value of a field into Proper Case and update a field with it:
For more details, including a sample database, read our new paper: Microsoft Access Query Tip to Convert a Text Field to Proper Case
September 11, 2017, 6:30 PM
Microsoft Headquarters, New York City
FMS President Luke Chung is the featured presenter at the Microsoft Access User Group meeting in New York City.
Watch him share his experiences and demonstrate FMS products for Microsoft Access, SQL Server, Azure cloud computing, and techniques to improve your productivity.
August 11, 2017
Total Access Emailer is the most popular email program for Microsoft Access.
We've created new articles for Total Access Emailer to work with SMTP servers from Microsoft Office365 and Google Gmail:
July 21, 2017
New versions of Total Access Detective are available for Microsoft Access 2016, 2013, 2010 and 2007.
Enhancements:
- 2016 Version: Support for the new update of Access 2016 in May 2017
- 2016, 2013, 2010 Versions: Comparison of Data Macros in ACCDB databases
- Two database comparison, Object Selection screen enhancements highlight objects with different modification dates and filtering
- If you resize datasheet columns while viewing the Total Access Detective results, your column widths are preserved the next time you reopen the form
- Improved user interface with increased font sizes
- Automatic selection of A4 paper size for international users
- More trapping of Access database errors
- New user manual and help file
- and more...
For more information, visit:
- Total Access Detective 2016, Version 16.01 Enhancements
- Total Access Detective 2013, Version 15.5 Enhancements (replaces version 15.0)
- Total Access Detective 2010, Version 14.51 Enhancements
- Total Access Detective 2007, Version 12.91 Enhancements
This is a free upgrade for people on a support contract and owners of the 2016, 2010, and 2007 versions. Existing Total Access Detective 2013 customers can upgrade at a discounted price.
FMS President Luke Chung was a presenter at the Microsoft Access DevCon 2017 in Vienna, Austria in early April.
Before giving two conference presentations, he was sat down and spoke with Philipp Stiefel of codekabinett.com of Germany discussing VBA development.
They talked about:
- VBA Best Practices
- How end-users migrate from Excel to Access, then learn how to code
- Why people are hesitant to purchase third party products and how FMS overcomes that by showcasing the value we offer
- Using tools like Total Access Analyzer to catch errors before shipping and learning best practices
- Using the module code in Total Visual SourceBook to address problems we've already solved so you can focus on the unique issues in your applications
- The value of creating consistent, quality code How to improve code for developers of all backgrounds
- Being in constant "growth" mode to look for ways to become a better developer
April 1-2, 2017, Hotel Strudlhof
FMS friend and Microsoft Access MVP Karl Donaubauer is organizing a Microsoft Access conference in his hometown of Vienna, Austria the weekend of April 1-2, 2017. Please let him know if you are interested in attending. He has organized many Access conferences in Germany. This is the first in English.
FMS President Luke Chung is a featured speaker and will discuss Microsoft Access Strategies and Products. Many of the world's leading Microsoft Access developers will be speaking with Luke. Visit the agenda to learn more.
Arrive a day early for a free guided tour of the beautiful and historic city of Vienna, a UNESCO World Heritage site.
For more information and registration, visit: Access DevCon Vienna
January 9, 2017
Build 16.00.0015 was released and is available for free to all Total Visual Agent 2016 customers. For more information on the update, visit Enhancements in Total Visual Agent 2016, Build 16.00.0015
The Total Visual Agent Version and Updates page was also enhanced to show the history of the product since its debut 20 years ago
The Sean Hannity Radio Show, January 4, 2017
Background
The day after an amazing personal interview of Julian Assange by Sean Hannity aired on his TV show, FMS President Luke Chung was invited to discuss the related technology on his radio show.
Hannity traveled to London to interview Assange at the Ecuadorian Embassy where he’s seeking asylum. They discussed an overview of Assange’s role as founder of WikiLeaks, and their obtaining and publishing the emails from the Democratic National Committee the weeks before the US Presidential election. Some people attribute Hillary Clinton’s loss to the revelations in those emails especially from John Podesta, the former White House Chief of Staff and Chairman of the Clinton campaign. They are also accusing the Russians for hacking (stealing) and providing the data to Assange so Donald Trump could win the election.
Radio Show
On January 4, 2017, Luke was on the radio show with Sean Hannity and Brigadier General Eli Ben Meir, former Israeli Military Intelligence chief. The three of them discussed the WikiLeaks disclosures. Luke commented specifically on:
- Cyber attacks and the security breach at OPM disclosed non-classified government employees and by omission who were covert at American Embassies globally.
- Noting Julian Assange’s careful word choices to exclude Russia as source without excluding them as the ultimate source of his sources.
- The need for WikiLeaks’ to keep their sources confidential and how they amplified the data from Bradley Manning and Edward Snowden.
- Different approaches to preventing cyber attacks depending on the cause.
“It’s one thing when someone steals your car because they broke into it. It’s another thing when someone steals your car because you left your keys in the ignition.”
To listen to the interview and more insight on these issues, visit Luke Chung's blog post:
Sean Hannity Radio Show Interview on Julian Assange, WikiLeaks, Russian Hacking, and Cyber Warfare
December 21, 2016
Total Access Admin lets you monitor users going in and out of your databases in real-time. See who's currently in your database and who recently exited, create a log of connections and disconnects, compact the database after everyone exits, etc. Monitor all the databases across your network from one installation of Total Access Admin.
Total Access Admin 2016 includes many new features.
- Does not require Microsoft Access to be installed on your machine
- Works in environments where either Access 32 or 64-bit versions is installed, including installations from Microsoft Office365
- Up to 150 databases can be monitored at one time (up from 100)
- Setup program supports Windows 8 and 10, and has an option to launch the program after its installed
Read our New Features page for details.
Download the free, fully-functional
Trial Version to see how helpful Total Access Admin can be for
you. Existing customers can upgrade at a discounted price.
November 30, 2016
A new version of Total Access Statistics is now available for Microsoft Access 2010 (32 and 64-bit versions).
Running as an Access add-in Wizard, Total Access Statistics generates a wide range of numerical analysis beyond the power of queries. All results are in Access tables that you can add to your queries, forms and reports.
The new 14.1 version is an update from version 14.0 which was released in 2010 and includes many new features:
- Compatibility with the latest versions of Windows and runtime library
- The VBA runtime libraries in the Professional Version are upgraded so you can support users running your application in Access 2013 and 2016.
- Additional Percentile Types can be assigned to a field in your table
- Data formatting enhanced
- Performance improvements
- Improved financial calculations
- Updated User Manual and Help File
Here's more information on Total Access Statistics 14.1 Enhancements.
The
Free Trial was updated so you can experience it yourself.
Existing Total Access Statistics owners can upgrade at a discounted price.
September 26, 2016
We released update 16.00.0030 for Total Access Startup 2016 to address a few issues:
- Special Handling for Autoexec Macros
- Run the Administrator Program on Machines without Microsoft Access Installed
- User Manual and Help File Updated
For more information, visit our Total Access Startup 2016 update page. Existing customers were notified via email for the free update.
Total Access Startup lets you centrally manage the deployment of Access applications for each user. Download the Free Trial to experience it yourself.
September 7, 2016
Total Access Analyzer, the most popular Microsoft Access add-in, offers comprehensive documentation and analysis of your MS Access databases so you can better understand individual objects, cross-references between objects, procedure and data flow diagrams, VBA module analysis, and much more. Detecting over 300 ways to fix and improve your databases, Total Access Analyzer improves the quality of your work, teaches you best practices, and increases your productivity.
Build 32 was released with enhancements and fixes listed by version:
- Access 2016 Build: 16.00.0032
- Access 2013 Build: 15.00.0032
- Access 2010 Build: 14.50.0032
- Access 2007 Build: 12.95.0032
Existing Total Access Analyzer owners were notified to download the update.
August 24, 2016
Total Visual Agent, the world's most popular maintenance scheduling tool for Microsoft Access/Office and Visual Basic 6 (VB6) is now available for Microsoft Access 2016 (and earlier). This is the ninth major release of Total Visual Agent and introduces many enhancements to automate maintenance chores easier than ever.
To keep your Microsoft Access databases healthy, you need to regularly compact them. For disaster recovery, you should also be making backup copies of your database regularly. You may also have regular tasks such as printing reports that are performed regularly. Total Visual Agent does this and much more on a schedule you specify. Run tasks hourly, daily, weekly, monthly or just one time. Perform database chores, run Access macros or Windows command lines.
A complete audit trail is maintained, and you can even be notified by email if something goes wrong. Total Visual Agent can also be run as a Windows service to restart if the machine reboots and for added security since a user doesn't need to be logged in.
Total Visual Agent 2016 leverages our vast expertise, and offers the best database management solution with many new features:
- Supports Microsoft Access 2016
- Supports Windows 8 and 10
- Does Not Require Access to be Installed on your PC
- Database Lock Error Identifies Offending Machines
- Activity Log is Separated from Settings Database
- Activity Log Shows Duration of Each Activity
- Email Notifications Support TLS and Office365 SMTP
- Tasks are Not Run at the End of an Event
- Interval Enabled/Disabled Status Shown on the Event Form
- More Robust Windows Service Feature
- Improved Monitor Settings Tab
- Default Location of Archive and Extract Folders Moved
- Improved Setup Program
- New user manual and help file
- and More...
Download the
Free Trial to experience it yourself.
Existing Total Visual Agent owners can upgrade at a discounted price.
August 15, 2016
With the release of Total Access Emailer for Microsoft Access 2016, we've released updates for versions for Access 2013, 2010, and 2007:
- Version 15.7 for Access 2013
- Version 14.7 for Access 2010
- Version 12.7 for Access 2007
Existing customers with a current priority support agreement receive free upgrades. Customers without a support contract can upgrade for a nominal fee.
Running as an Access add-in Wizard, Total Access Emailer lets you send personalized emails to everyone in your table or query. Easily customize messages using fields in your data source, attach files on disk, and add Access reports as PDF files that can be filtered for each recipient.
A variety of new features are added to the X.7 version:
- Validate the Email Addresses in Your Email Blast Before Sending It
- Save Attachment Files to Disk in Addition to or Instead of Emailing
- Updated Documentation
- Support for Office365 and other SMTP Services using TLS
For more details, visit the New Total Access Emailer X.7 Features page
Download the
Free Trial to experience it yourself.
Existing Total Access Emailer owners can upgrade at a discounted price.
June 30, 2016
A few years ago, we migrated our email service to Microsoft's Office365 cloud service. Overall, it's been very reliable and eliminated the challenges we had hosting Exchange ourselves. It let us get to our emails using Outlook installed on Windows, any internet browser, and smartphones. Office365 also offered other Office product online (Access Web Apps, Excel, Word, etc.), SharePoint and OneDrive Business.
Unfortunately, on the morning of June 30th, we discovered:
Delays sending
and receiving emails Some emails were bouncing back from recipients who couldn't validate our Office365 Exchange Server's SMTP (protection.outlook.com) with our domain name.- That meant the Exchange SMTP server was no longer considered a trusted sender of emails from the @fmsinc.com domain.
- Our use of the Office365 SMTP server to send emails with our Total Access Emailer product was also failing to authenticate against the server
Needless to say, we aren’t happy about this experience which has impact us, our clients using Office365, and Office365 customers around the country.
For more information,
including Microsoft's response, read our new blog post:
Microsoft Office365 Exchange Server Performance Degradation and SMTP Problems
June 13, 2016
Total Access Emailer, the most popular email program for Microsoft Access, is now available for Access 2016 (32 and 64-bit versions).
Running as an Access add-in Wizard, Total Access Emailer lets you send personalized emails to everyone in your table or query. Easily customize messages using fields in your data source, attach files on disk, and add Access reports as PDF files that can be filtered for each recipient.
A variety of new features are added to the Microsoft Access 2016 version:
- Validate the Email Addresses in Your Email Blast Before Sending It
- Save Attachment Files to Disk
- Preview Saving Files to Disk
- New VBA Function to Preview Email Blasts with Files
- Code Generator Supports Preview Email with Save Folder
- Updated Documentation
- Support for Office365 and other SMTP Services using TLS
For more details, visit the New Total Access Emailer Features page
Download
the Free Trial to experience it yourself.
Existing Total Access Emailer owners can upgrade at a discounted price.
May 4, 2016
Total Access Statistics is now available for Microsoft Access 2016 (32 and 64-bit versions). Running as an Access add-in Wizard, Total Access Statistics generates a wide range of numerical analysis beyond the power of queries. All results are in Access tables that you can add to your queries, forms and reports.
Total Access Statistics includes a VBA programmatic interface with a royalty-free runtime distribution library so you can add the advanced analysis into your Access applications for distribution to others.
Download the
Free Trial to experience it yourself.
Existing Total Access Statistics owners can upgrade at a discounted price.
April 11, 2016
We are delighted to announce new versions of Total Access Startup for Microsoft Access 2016 and 2013. Total Access Startup makes it easy to deploy the latest version of your Access database to each user's desktop and launch it with the right version of Access.
Many new features were added:
- Support for Microsoft Access 2016 and 2013 while specifying bitness: 32-bit, 64-bit or both
- Optionally specify a specific range of allowable Microsoft Access versions
- New tabbed Administrator Wizard interface to simplify setting the options
- Ability to add a graphic file for a professional splash screen as the program loads (including replacing the Access splash screen)
- Add an icon to the distributed shortcut from our library of 1,150+ icons
- Customize and localize any of the user messages to your own words and language
- New manual and help file
- For additional details, visit New Features in Total Access Startup 2016
Download the
Free Trial to experience it yourself.
Existing Total Access Startup customers can upgrade at a discounted price.
March 9, 2016
On March 8, 2016, Microsoft released an update KB3085515 for Office 2010. It addressed some VBA issues for Excel. Unfortunately, the update of the VBE7.DLL file causes many Microsoft Access databases to fail. A heated thread on the Microsoft Community forum describes the problem: KB3085515 breaks MS Access 2010 reference
FMS President Luke Chung wrote this blog post to describe the cause of the problem, and the impact it has on Access wizards and databases people create. Information is also provided with illustrated step-by-step screenshots to uninstall the update.
Microsoft Office 2010
Update KB3085515 Causes Access ACCDE and MDE Databases to Crash
New Paper: Tips and Techniques for Setting Up Remote Desktop Connections and Using Multiple Displays
March 7, 2016
Learn how to setup Windows Remote Desktop Connections so you can run other PCs from your machine. Whether it's another PC on your desk, across the hall or another site, Remote Desktop lets you run other machines without leaving your chair. This new paper covers how to configure a PC to allow this, troubleshoot some of the common problems and enable your connection to take advantage of multiple monitors.
New Paper: Tips and Techniques for Setting Up Remote Desktop Connections and Using Multiple Displays
January 7, 2016
We are delighted to announce new versions of Total Access Detective for Microsoft Access 2010 and 2007.
In conjunction with the release of Total Access Detective for Access 2016, we've added many of the new features for the 2010 and 2007 versions to help you pinpoint differences between your Access databases and objects.
For details, visit:
- Total Access Detective 2010, Version 14.5 Enhancements (replaces version 14.0)
- Total Access Detective 2007, Version 12.9 Enhancements (replaces version 12.8)
This is a free upgrade for people on a support contract. Other existing Total Access Detective customers can upgrade at a discounted price.
December 14, 2015
FMS President Luke Chung participated in a live studio interview with Greta Van Susteren on her evening show, On the Record. Discussing the tragic San Bernardino, CA terrorist incident, Greta questioned how the State Department could have allowed the terrorists to enter the country. Luke confirmed how Google and Twitter searches can be used to screen immigrants, along with the challenges of tracking people intent on hiding their identities and activities with multiple aliases.
FMS has experience with law enforcement and counter-terrorism through our Sentinel Visualizer data visualization program that helps analysts find hidden relationships among people, places, and events. (more media)
December 18, 2015
We
are delighted to announce the release of Total Access Detective for Microsoft Access 2016 and 2013.
Total Access Detective lets you quickly find differences between any two databases or two objects in your current database. Know exactly what
changed at the table, field, property, control, macro line and VBA module code level. You can even compare tables for data differences.
The latest version offers many enhancements from the previous versions:
- Support for the 32 and 64-bit versions of Access 2016 and 2013
- Module and Text Comparison Option to Ignore Line Numbers
- Search Bar to Filter Objects and Properties by Name
- See and Filter Tables based on Whether it’s Linked
- Procedures with Differences List
- New Manual and Help File
For more information on the enhancements, visit: Total Access Detective 2016 and 2013
Existing Total Access Detective customers can upgrade for a discounted price.
December 2015
Total Access Analyzer, the most popular Microsoft Access add-in, is now shipping for Microsoft Access 2016. Total Access Analyzer offers comprehensive documentation and analysis of your MS Access databases so you can better understand individual objects, cross-references between objects, procedure and data flow diagrams, VBA module analysis, and much more. Detecting over 300 ways to fix and improve your databases, Total Access Analyzer improves the quality of your work, teaches you best practices, and increases your productivity.
Total Access Analyzer 2016 includes many new features to help Microsoft Access developers create better solutions:
- Support for Microsoft Access 2016, 32 and 64 bit versions
- New Suggestion: Incorrect Link to Subforms
- New Suggestion: Relationship Field Cross-Reference and Field Type Comparison
- Enhanced Cross-Reference of Aliased Tables in Queries
- Pass-Through Queries are Not Cross-Referenced
- Windows 10 Support
- New Manual and Context Sensitive Help
For additional details, visit New Features in Total Access Analyzer 2016. Existing customers can upgrade at a discounted price. A demo version is available.
December 2015
Total Access Speller helps you avoid typos on the screens your users see. Spell check labels, captions, validation text, status bar, navigation bar, and other properties to avoid embarrassing mistakes. It is now available for Microsoft Access 2016. A free trial is also available.
October 21, 2015
Microsoft Office 2016 was recently released. For the most part, Microsoft Access 2016 didn't change much. Unfortunately, it includes a serious bug that makes it challenging to adopt it.
Picture images on forms and reports (which work in MS Access 2013 and earlier) appear blank in the 32-bit version of MS Access 2016.
Learn
more about the issues and solutions in this blog post: Microsoft Access 2016 and Invisible Picture Images
October 10, 2015
We've redesigned our website with a new home page, menu system, search, and other features to make our site more appealing, more functional, and easier to navigate.
It's now hosted by the Microsoft Azure cloud with a SQL Azure database.
We hope you like the new design.
August 2015
In conjunction with the release of Total Access Analyzer for Microsoft Access 2013, we've created updates for earlier versions of MS Access:
Click on the links for detailed information on the new features. Customers on an annual support contract receive the new versions for free. Other customers can purchase an upgrade.
Learn more about the updates in this blog post:
Total Access Analyzer 2010, 2007 and 2003 Updates Ships
July 29, 2015, Neil Cavuto's Coast-to-Coast Show
FMS President Luke Chung had a live interview on July 29 with Neil Cavuto on his FOX Business News show Coast-to-Coast. Luke chatted about text and email technology related to NFL Quarterback Tom Brady's destruction of his smartphone. Unfortunately, Fox did not release an online copy of the interview, so we can't share it. Read more information in Luke's blog about the experience: Appearance on FOX Business News for Tom Brady's Destroyed Text Messages.
July 6, 2015
The most popular Microsoft Access add-in of all time, Total Access Analyzer provides detailed documentation and analysis of MS Access databases to help you better understand how your objects work together and 300+ ways to detect errors, find unused objects and VBA code, improve performance, and conform to best practices.
Total Access Analyzer is now available for Microsoft Access 2013 with many new features:
- Supports Microsoft Access 2013, 32 and 64-bit versions
- New documentation of Conditional Formatting
- Documentation of Navigation Control and Buttons
- Documentation of Web Controls
- New Control Type Reports
- Support Procedure Calls to Libraries
- 3 New Module VBA Coding Suggestions
- Enhanced VBA Module Parser for Compiler Conditionals
- New Search Bar for Selecting Objects
- Improved Open Documentation Form
- Report Filter Shows Count of Issues
- New Treeview with 64-bit support
- Updated user manual and help file
- and more!
Here's a complete list of New Features.
For more information on the the new Total Access Analyzer read our blog post:
Total Access Analyzer Ships for Microsoft Access 2013.
June 1, 2015
With all the new features added to Total Access Admin 2013 in April, an updated version 11.6 for Access 2003 was released.
The primary difference between the 2003 and 2013 version is that the 2003 version doesn't require installing Access 2007 or later on the machine in order to support the ACCDB database format. It supports Access databases in MDB formats and does not require Access to be installed on the PC.
The new version replaces version 11.5 and includes many new features:
- Translates obscure computer names to a more understandable user name from a list you maintain.
- Enhances the activity log database to include user names.
- Increases the maximum number of databases that can be simultaneously monitored from 50 to 100.
- Supports specifying a time for the program to quit (exit).
- Adds new command line parameters to specify the hours and seconds to wait before quitting.
- Adds setup options to install for the current user or machine to support User Access Control rights as established by your Windows login.
- Includes a new user manual and help file.
Visit our New Features page for details.
April 22, 2015
Total Access Admin lets you monitor users going in and out of your databases in real-time. See who's currently in your database and who recently exited, create a log of connections and disconnects, compact the database after everyone exits, etc. Monitor all the databases across your network from one installation of Total Access Admin.
Total Access Admin 2013 includes many new features. You can now maintain a list to translate computer names to more friendly user names, manage up to 100 database in one screen (up from 50), specify a time to close the program, more command line parameters, new forms to view the activity log, and more. Read our New Features page for details.
Download the free, fully-functional Trial Version to see how helpful Total Access Admin can be for you. Total Access Admin 2013 supports ACCDB databases created in Microsoft Access 2013, 2010 and 2007, plus MDB databases created in any version of Access. Existing customers can upgrade at a discounted price.
Microsoft MVP Daniel Pineault wrote a nice review of our Total Access Detective product to find differences between his Microsoft Access databases:
Final Verdict
"I am once again quite confident in putting my stamp of approval on this tool. If you are in a situation in which you quickly need to identify all the differences between multiple databases, FMS' Total Access Detective will make short work of the job at hand! ...
A very nice, easy to use and most importantly, effective and thorough tool!"
To learn more about what Daniel discovered and his experience, read his article: Total Access Detective – Review
March 26-28, 2015, Malvern, PA
Microsoft held their first US MVP Summit outside of Redmond at their offices outside of Philadelphia. FMS President Luke Chung participated and met with fellow Microsoft Access MVPs and MVPs with other specialties.
All the MVPs
Access MVPs: Andy Tabisz, Jack Leach, Dirk Goldgar, Luke Chung, and Scott Diamond
Doug Ware, former Access MVP and current SharePoint MVP
We've completely revamped our Microsoft Access to SQL Server Upsizing Resource Center with links to all our related whitepapers and Microsoft resources to help with the whole upsizing process and use of SQL Server Express. We have several new and updated resources:
- Microsoft SQL Server Express: Version Comparison Matrix and Free Downloads
For the first time, all the different versions of SQL Server Express from 2005 to 2014 are shown, compared, and referenced with download links. This content required extensive research to document the details of which operating system each SQL Server version supports. Just because Microsoft web pages list the versions they support doesn't necessarily mean it works when you actually try to install it. - Automating the Backup of Your Microsoft SQL Server Express Databases
If you're using SQL Server Express, you still need to create backups of the database. Here's how to automate it. - When and How to Upsize Microsoft Access Databases to SQL Server
The original version of this was written for Microsoft when they selected us for a joint national campaign a decade ago to promote Microsoft Access to SQL Server Upsizing. We've updated it to better explain why and why not people should upsize their Access databases and an overview of what the options are and what to do.
Total Access Emailer lets you send personalized email blasts from Microsoft Access databases using your data and reports. It bypasses the limitations of Microsoft Outlook and MAPI by using SMTP.
Google offers a free SMTP server for gmail accounts that you can use with Total Access Emailer. Google recently added an extra security setting that you need to specify to enable the smtp.gmail.com feature.
Read our updated Total Access Emailer FAQ for more details.
November 5, 2014
We are delighted to announce the release of Total Visual SourceBook 2013. Total Visual SourceBook is our royalty-free source code library for Microsoft Access/Office VBA developers and Visual Basic 6 (VB6) developers.
The new 2013 version is an upgrade to our Total Visual SourceBook 2007 version. The new version is especially designed for the new features introduced in Microsoft Access/Office/VBA 2013 and 2010. It can also run in Access/Office 2007 and older versions through Access/Office 2000.
New Features
Total Visual SourceBook 2013 includes 35 new modules, 25,000+ more lines of code, enhancements to existing modules including VBA code that’s compatible with 32 and 64-bit versions of Office.
The user code database can now be upsized to SQL Server to simplify sharing code among your developer team. The new version also includes many enhancements to the code browser to simplify your experience in viewing, searching, adding, editing, and applying different error handlers to the source code.
For a complete list of enhancements, visit our New Features page.
Additional Resources
- Overview and Screenshots
- Summary of Code Categories
- Module and Class List
- Two Page PDF Product Flier
- Sample Code
- Awards and Reviews
For more information on Total Visual SourceBook read our Blog post:
Total Visual SourceBook 2013 Ships
September 23, 2014
FMS President Luke Chung was quoted in today's New York Times article HealthCare.gov Is Given an Overhaul. Robert Pear asked Luke about the overhaul that the Healthcare.gov web site needs. He quoted Luke with:
“Instead of being user-friendly, the original website was user-hostile”
In response to the quote, Luke wrote a new blog post covering some of the issues the original designers of the Healthcare.gov site missed, and how a data entry application should be designed. It's not that difficult if you know what you're doing and have done it before:
Designing a Data Entry System Properly; Overhauling the Healthcare.gov Web Site
August 18, 2014
Total Access Analyzer is the most popular Microsoft Access database documentation program. In our pursuit of excellence, we have released free updates of Total Access Analyzer 2007 and 2010.
Two updates were released:
- For Microsoft Access 2010, Version 14.01.0007
- For Microsoft Access 2007, Version 12.91.0007
The updates include the following fixes and enhancements:
- Module Cross-Reference incorrectly listing procedures that didn't exist when they existed
- Improved SQL query parsing to better cross-reference table and field names passed as function parameters
- For secure databases, document queries even when logged in without admin rights
- Support documenting library references of long DLL file names and paths
- Setup issues resolved for certain machines and motherboards
- For Microsoft Access 2010, 64-bit version, support Windows 8
Click on the links above for more details. Existing customers should have received email notification to download an update. If your email address changed, contact us to update your information.
Visit our new Microsoft Outlook Tips and Techniques site where we've consolidated our white papers on using Microsoft Outlook more effectively:
- Add a delay to your messages so you can catch mistakes
- The difference of the impact of time zones on smartphones versus computers
And more!
Evening of September 8, 2014, Microsoft Headquarters
FMS President Luke Chung is the featured guest speaker for the Microsoft Access User Group meeting in New York City.
Luke will discuss and demonstrate FMS products for Microsoft Access, and answer any questions about his experiences with technology, media, and business.
Join him at this free event. More details to follow on our Upcoming Events page.
We've updated several white papers:
- Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by Access Version)
- Creating an Annual 12 Month Summary Report without VBA Code by Creatively Using a Microsoft Access Crosstab Query
- How to Rename a File or Folder (Directory) from VBA, Visual Basic 6, Microsoft Office/Access/Excel
- From Microsoft: Free eBook: Microsoft Access Keyboard Shortcuts
Visit the main Microsoft Access Developer and VBA Programming Help Center site for more resources.
July 31, 2014
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.
Download the free trial version and send your own personalized emails from Microsoft Access.
You've created a Microsoft Access database solution and have successfully distributed it to many people. Everyone is running it properly but one machine is triggering this error. The error message makes no sense and everything you try fails to resolve the problem. What's going on?
Read our new paper Microsoft Access "Class Not Registered" Run-time Error '-2147221164 (80040154)' to learn more about why this occurs and how to resolve it.
How did the IRS not have backups and lose Lois Lerner's emails and other files? Who came up with their backup and disaster recovery plan? Wrong policies, incorrect execution? Incompetence or intentional?
Hannity TV Show on June 19, 2014
A 3.5 minute live interview with Sean Hannity in New York with Luke at their Washington, DC studio.
Sean Hannity Radio Show, June 20, 2014
A more in-depth 14 minute discussion with David Kennedy on the radio show. Luke starts at about 2:30 after the introduction.
Additional appearances on the Sean Hannity TV and Radio Shows, Other Shows
Have you been curious about Microsoft cloud offering of Office365? No longer interested in hosting your own Exchange Server? Want to have your infrastructure in a secure data center with high reliability and resilience?
If so, we have Free Trials for Office365. We also have trial links to Microsoft Dynamics CRM. Test it out and see if you like it.
We switched to Office365 over a year ago starting with our Exchange Server. We already had our email hosted offsite, but moving it to Office365 was relatively smooth and made it easier and cheaper to support different mobile devices. We then migrated our SharePoint platform to Office365. That was a bit more challenging with the changes between SharePoint versions.
Now with our hosted SharePoint site, we're experimenting with Access 2013 Web Apps
that are integrated directly with SQL Azure databases for our internal and external users. Since it's hosted on SQL Azure,
you can also link to the tables directly from your Access desktop databases.
Try it out for free and see what you think.
FMS has worked with Microsoft Access since it debuted in 1992. There have been many Access versions since then with multiple service packs, hot fixes and updates. This paper offers a list of what and when it was released, feature differences between versions and additional details for the more recent versions.
To help us remember all the versions and changes, we've written a new article summarizing the evolution of Microsoft Access: Microsoft Access Version Releases, Service Packs, Hotfixes, and Updates History.
Here's a related article we introduced in the last newsletter that is updated with a link to the new Microsoft Access 2013 SP1 Runtime download: Microsoft Access Runtime Distribution and Free Downloads
Visit our Microsoft Access Developer Help Center for additional articles with tips for creating great solutions.
June 5, 2014
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
- Support 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.
Read our new paper Microsoft Access Error 3045 Could Not Use Database; File Already in Use May Not be Due to an Exclusive Lock to learn how different workgroup security files may trigger this error.
Read our updated paper on why you should Avoid Using Decimal Fields in Microsoft Access Tables
Remote Desktop lets you connect to a computer located elsewhere and run it as if you were there. Unfortunately, the remote computer’s Start menu only shows options to "Log Off" and "Disconnect". It does not offer the standard "Shut Down" options: Log off, Shut down, Restart, Stand by, Hibernate. If you attempt to use Ctrl+Alt+Del, the command is captured by the local machine and not the remote one.
Read our paper on Rebooting a Remote Desktop Computer to Restart It on how to get around this problem.
The Microsoft Access 2013 Runtime, Service Pack 1 was just released. Get the free download if you want it. Keep in mind that many features which exist in Microsoft Access 2010 no longer exist in Access 2013, so if you need them, you may be better off staying with the Access 2010 runtime which is also free. Visit our Microsoft Access Runtime Download page for more details and free download links for the different Microsoft Access versions.
Microsoft Access program managers gave four presentations at the recent SharePoint conference in Las Vegas. Their presentations covered how Access 2013 Web Apps can be created on SharePoint 2013 and automatically uses a SQL Server database (hosted in SQL Azure).
Links to the four videos are here: Microsoft Access Videos from the SharePoint Conference
March 21, 2014
Total Visual Agent 2013 with support for Microsoft Access 2013, 2010, and 2007 is now shipping. The 2013 version includes many new features from the 2007 version:
- Support for Microsoft Access 2010 and 2013
- Support for 64 bit Operating Systems
- Simplified Startup and Easier Management of Multiple Microsoft Access Versions
- Import Settings from Multiple Versions of Total Visual Agent
- Test All Actions for an Event, Database, Directory or Task Group
- Create Events that Run Every X Minutes
- Create Events that are Limited to Periods Spanning Midnight
- Process Directories with Managed Databases
- Data Extract Tables are Keyed
- Run Macros for Database Password Protected Databases
- Pause for a Fractional Minute
- Compressed Archive File Names Support Multiple Extensions
- More Detailed Activity History Log with Deletions
- More Detailed Database Statistics with Deletions
- Add Your Comments to Events, Directories, and Actions
- Simplified Addition of New Actions
- More Modern and Improved User Interface
- New User Manual and Help File
- And More...
A fully-functional, free trial is available. Existing owners of Total Access Agent can upgrade at a discounted price.
February 19, 2014
Two new versions of Total Access Speller are shipping for Microsoft Access 2013 and 2010. Many new features were added since the 2007 version:
- Support for Microsoft Access 2010 and 2013, with 32 and 64-bit support
- Machine and User Installation Options
- Improved Spell Checking of Macros
- New Option to Ignore Invisible Controls
- Property List Shows Built-In Status
- Enhanced user manual and help file
A free trial is available. Existing owners of Total Access Speller can order an upgrade at a discounted price.
Creators Still in Demand on Health Care Website
February 11, 2014
Robert Pear of The New York Times called Luke and quoted him in this article: Creators Still in Demand on Health Care Website
The
contract for the Healthcare.gov site has moved from CGI Federal to Accenture, but Accenture doesn’t really have a
better team to put in place. In the typical large government contractor world, the winner of a contract simply hires the existing team and moves
them to their payroll. The people who do the work remain and change their business cards. Do we really expect significant improvements from a team that
created the original site and thought it was ready for the public?
"This appears to be a typical government contract shuffle,” Luke Chung, the president of FMS, a software development company in Vienna, Va., said of the handoff. “A new company wins the contract and hires many of the old people. It happens all the time in government."
December 15, 2013
FMS President Luke Chung provides a detailed technical assessment of the new Healthcare.gov web site in this new blog post
Who Thinks the Relaunched Healthcare.gov Performance Metrics are Acceptable?
Thanksgiving Week 2013
A crazy week of media. Before leaving town, FMS President Luke Chung was interviewed in Washington DC. Then while visiting family for Thanksgiving, the national media sent news crews and booked studio time in Sarasota, Florida to get his comments about the soon to be updated Healthcare.gov web site.
Luke appeared on a panel with three others for a live interview discussing the relaunched Healthcare.gov web site.
His appearance is available and summarized by Noah Rothman in this article: Tamron Hall Interrogates Tech Expert After He Criticized Supposed ‘Improvements’ to ACA Site
ObamaCare: Mistake or moneymaker?
A one-on-one interview with Clayton Morris for four minutes discussing how large government contractors profit from delivering systems that don't work:
"If we follow the money, we'll see the stink in the system...Too Big to Fire"
Featuring Sarasota Bay behind him.
Tory Dunnan had a Skype call with Luke to better understand the capacity of the relaunched Healthcare.gov site. This interview was cut into multiple stories that aired all day long. Here's one of them appearing at 1:30:
"So the challenge isn't how many lanes do you have on the highway, but it's how fast the cars can go down the highway. Because if there's any breakdown, you can have a big traffic jam and pile up behind you."
More details: Deadline Day: Obama administration 'on track' for website goal, agency says
Crucial Weekend for Healthcare Web Site
A portion of Luke's taped interview from yesterday was also included in the following morning's Today Show at 1:06:
"The system either works or it doesn't work....the 50,000 number that they've put out is a little ambiguous because what one wants to know is how many people per hour can get through the system."
Deadline hours away for Obamacare website fixes
The Obama administration has just one day to get its Healthcare.gov website running more efficiently, but officials are already trying to limit expectations once again.
This was the lead story of the evening news. Starting at 0:45, Luke makes a few comments in response to Secretary Sebelius' comments that people should use the new Healthcare.gov web site during off-peak hours:
"It tells me the system isn't full baked. This system should be able to accommodate as many people who want to get on as possible."..cut to President Obama..."50,000 is not a number that's unheard of for websites to be able to support at one time. So I think the challenge is not just the number of users, but whether there are still bugs in the system that will prevent the process from running smoothly."
FMS President Luke Chung has been a technical resource for Robert Pear of the New York Times since he originally quoted him in an article that kicked off all this media attention on October 8th. Yesterday they chatted about how a web site needs to be built to support maximum volume which will come on the deadline date. Quite a challenge since they can't even support the early volume.
His article appears on the front page: A Plea to Avoid Crush of Users at Health Site
Luke Chung, the president of FMS, a database company in Virginia, said building the website to handle 50,000 simultaneous users was “not unreasonable.” But he said the government must be prepared to handle much larger numbers at peak times like Dec. 23, just as the Internal Revenue Services does at the tax filing deadline in April.
White House: Enroll in Obamacare, but not too fast
After confirming he wasn't involved with the Healthcare.gov project, Luke was interviewed by Leigh Ann Caldwell about the new rollout while trying to board to flight at the airport:
Luke Chung, president and founder of Virginia-based software development company FMS Inc., said success for the website would be determined by both the number of users as well as how long they are in the system. He compared it to a highway, noting that 50,000 people traveling 60 miles per hour is smooth traffic while the same number going 10 miles per hour is a jam...Chung cited December 23 as the most significant deadline, noting that demand would be "huge" because people by nature wait until the last minute to act.
Will HealthCare.gov be in good health by Nov. 30?
Greta van Susteren is on vacation, so Luke chatted with Kimberly who was in New York City while he was on Greta's studio in Washington, DC. They discussed how these contractors are "Too Big to Fire"
"Over time, I'm beginning to see that these government contractors who took over this project have essentially made every decision that favors them as much as possible – to maximize the cost to taxpayers, to maximize their profits."
Related article by Greg Richter based on the broadcast: Software Developer: ACA Website Designers Just Lining Own Pockets
November 22, 2013, Seattle, WA
While attending the Microsoft MVP summit and Microsoft Access Day, CNN tracked down FMS President Luke Chung to interview him for the evening show.
He taped a segment from the Seattle studio which provided a nice Seattle Space Needle backdrop. Former Microsoft Access Program Manager, Tim Getsch, who is now the owner of Check Out My Cards (comc.com) joined him for the shoot.
Luke was asked to comment on the need for anonymous shopping on the Healthcare.gov website. He appears at 1:50 for a short quote in this 4:30 story:
"This is something people expect when they visit any web site to not disclose any personal information until they're at a point where they want to make a commitment to buy."
Watch the video: Where's the anonymous shopping perk?
November 21, 2013, Bellevue, WA
FMS President Luke Chung joined several other Microsoft Access MVP speakers at this one day event for Microsoft Access developers. In addition to Luke, speakers included the organizer Armen Stein of J Street Technology, George Hepworth, Tom van Stiphout, Andrew Couch from the UK, and Kevin Bell from Microsoft.
Luke discussed upsizing Microsoft Access databases to SQL Server and SQL Azure.
Visit the Access Day web site for more information.
November 13, 2013, Cannon House Office Building, Washington, DC
FMS President Luke Chung testified before the US House of Representatives Committee on Homeland Security about the Healthcare.gov website. This committee is responsible for all security issues on .GOV web sites. The hearing was entitled: Hearing: Cyber Side-Effects: How Secure is the Personal Information Entered into the Flawed Healthcare.gov? Luke is on the second of two panels.
Click on the blog post link for video of his five minute prepared testimony and responses to Chairman
Michael McCaul. His written testimony is also available. Under oath, he will
make a 5 minute statement then respond to questions from all the members of the committee:
Invited by the House Committee on Homeland Security to Testify about Healthcare.gov
FMS President Luke Chung continues to influence the national discourse on Healthcare.gov. The technically flawed website even led to President Obama talking about web site design. As someone who identified serious problems from the day it debuted (see earlier blog posts), Luke has been on numerous national TV and radio programs discussing the issues beyond too many users.
He also wrote a new blog post on how to redesign the site:
Creating a Healthcare.gov Web Site that Works
 |
|
 |
|
|
|
|
|
|
|
|
|
|
Read the blog from FMS President, Luke Chung, about his experience using the Affordable Care Act (Obamacare) web site when it debuted on October 1st.
Healthcare.gov is a Technology Disaster
Regardless of the politics, this web site is not ready for prime time. Luke offers his assessment with screenshots of several crashes he experienced. Bad design, bad development, and seemingly no testing for what should be an enterprise quality application.
As one of the few non-partisan technical reviews of the website, the blog has attracted a lot of media attention and showcased our decades of database development expertise.
Michael Shear of the New York Times interviewed and
quoted Luke in this October 8th article:
Health Exchange Delays Tied to Software Crash in Early Rush
"It's poorly designed," said Luke Chung, the president of a database company in Virginia who has publicly criticized the site in recent days. "People higher up are given the excuse that there are too many users. That's a convenient excuse for the managers to pass up the chain."
Luke was included in the national morning broadcast of CBS News. Read the text or watch the video in Obamacare website looks “like nobody tested it,” programmer says
“It wasn’t designed well, it wasn’t implemented well, and it looks like nobody tested it,” said Luke Chung, an online database programmer.
Chung supports the new health care law but said it was not the demand that is crashing the site. He thinks the entire website needs a complete overhaul.
“It’s not even close. It’s not even ready for beta testing for my book. I would be ashamed and embarrassed if my organization delivered something like that,” he said.
Luke was featured in an article on CNN entitled Obamacare glitches known ahead of time? Brian Todd came by the office to learn more about the challenges Luke encountered and the web site actually crashed while he was showing it.
ObamaCare website neither fast or easy? Peter stepped through the site and struggled to even get a user name. Then Luke made a few comments around 1:11 and at the end of the segment:
“It’s written as if it were created by people who had never created a database web application before…This can be fixed in a very short period of time, and it wouldn’t necessarily be that expensive”
KABC Radio Los Angeles (AM 790): McIntyre In The MorningLuke Chung comes on to talk about the root cause of Obamacare’s website hick-ups…
|
Ross Fire Show on KIRO Radio SeattleHere’s my interview with Dave Ross of Ross Fire on KIRO Radio, a CBS Radio station in Seattle:
Database expert Luke Chung has suddenly become an expert on the failings of the Obamacare computer system, all because it kept crashing as he tried to get a quote. Dave Ross and Luke go in depth on what Luke found after he dug into it (stunning ineptitude) and how he could fix it easily for a fraction of the cost. Whether you’re a geek or not, you’ll enjoy this fascinating conversation. This is Luke's most in depth interview on the HealthCare.gov website. It includes his experience meeting with the House Energy and Commerce Committee staffers on Thursday, ways to improve the system, and how the Affordable Care Act can help FMS and other small businesses. |
Total Access Emailer Customer Shares His Experience
George Moore, an Access developer from Dallas, Texas shared his recent experience implementing Total Access Emailer.
"Bought and configured Total Access Emailer for a client to send out numerous Alert reports to various people in the organization. Works like a champ (which is what I've come to expect from FMS), makes my client contact look like a genius and is helping the organization go through a complete culture change as a result of timely analytical reports."
"You guys ROCK!!! Thanks for all you do to help us in the field."
Thanks George for your kind words. We're thrilled your client is able to transform their operations with our product and how easy it was for you to implement! For additional customer testimonials, visit our Total Access Emailer Reviews page.
Microsoft Access and Office 2010 Service Pack 2 (SP2) Enhancements and Issues
New Paper on the enhancements and issues related to the recent release of Microsoft Office 2010, Service Pack 2 (SP2).
Includes download instructions, details about the products affected, the list of enhancements for all the products and Microsoft Access, the Access 2010 runtime version, known issues including a confirmed bug between Access 2010 SP2 and SharePoint 2013, and additional Microsoft Office resources.
New Tip: Do Not Install Microsoft Access Add-ins and Databases in the Program Files Folder
Microsoft Access add-ins and databases should never be installed in the C:\Program Files folder. Learn more about this issue related to User Access Control even if the user has administrative rights on our support page, Do Not Install Microsoft Access Add-ins and Databases in the Program Files Folder.
New Case Study: Inspection Software for the National Archives and Records Administration (NARA)
To ensure the quality of work performed by their Facilities Management service providers, the National Archives and Records Administration performs both random and targeted inspections of completed work orders.
FMS was selected to create a professional, multiuser system to collect the inspection results electronically and generate a variety of management reports.
Within two months, we deployed our solution which offers data entry screens to replicate a variety of existing forms and many new management reports. An intuitive user interface made it easy for users without requiring extensive training. More importantly, we established a solid database foundation to improve NARA processes both today and into the future.
Read the Case Study, Inspection Software for the National Archives and Records Administration (NARA).
New Tip: Microsoft Access Inconsistent Compile Error for a Field Reference in a Form
Discover what we learned when we encountered a database that would inconsistently lose its compiled state for some users. The compiler would flag field references to the form's RecordSource as missing fields, but the fields existed. So why was this happening at random times for different users?
It turns out that it's due to programmatically changing the RecordSource of forms, which may not be the form where the compile error is triggered.
Learn more about this on our blog,
Microsoft Access Inconsistent Compile Error for a Field Reference
in a Form.
Two FMS Products are on Microsoft MVP Mark Tabladillo's 2013 Recommendation List
FMS is pleased to share that our Total Access Analyzer and Total Visual CodeTools are featured on Mark Tabladillo's product recommendation list for 2013.
His recommendation list include products for analytics, big data, and data mining professionals and based on his personal use of them.
Glad you found them valuable and thanks for taking time to provide the endorsements!
Try the free trials for Total Access Analyzer and Total Visual CodeTools and see for yourself.
New Technical Support Forum and Ticket Tracking
We are very pleased to announce our new technical support site (http://support.fmsinc.com) to provide forums and the ability to submit technical support tickets.
Our new site lets you submit requests and respond to them via email with our support team. It also lets you visit our site to check the status of your requests and their entire chain of communications. You can login directly or use affiliated logins from Facebook, Google, and Twitter.
You can also read information and ask questions to the community. We hope you'll join us.
New Paper: Comparison of Microsoft Access, LightSwitch and Visual Studio Platforms for Database Developers
Microsoft Access started at the beginning of the Windows revolution 20+ years ago and became the most popular database of all time. More recently, additional technologies have become significant, so it behooves the Microsoft Access community to be aware of the trends and options. A variety of platforms and options are available with benefits and limitations with each. Meanwhile, Microsoft Access is also evolving with their latest Access 2013 version offering new web based solutions.
Read our new paper entitled Comparison of Microsoft Access, LightSwitch and Visual Studio Platforms for Database Developers on what we're seeing and experiencing.
Be Careful Making Appointments on Your Smartphone from a Different Time Zone
When travelling in Texas recently, I received an email for a noon lunch appointment the following week. So I added it to Outlook on my Windows Phone as usual.
Unfortunately, I missed the appointment because when I returned home to Eastern time, the appointment appeared on my calendar as 1 PM (noon in Texas). Rude, embarrassing, and bad for business.
Read our new paper on why and how to avoid this, Missing an Appointment Set on a Smartphone while in a Different Time Zone.
Sentinel Visualizer Mentioned in MIT Technology Review with Boston Marathon Bombing
As the rampage and manhunt in
Boston transpired, MIT Technology Review published an article that mentioned our Sentinel Visualizer product from our Advanced Systems Group.
In the article, David Talbot describes the rise of technology to detect the activities of criminals over the Internet and connect seemingly unrelated people, places and things.
Through the power of link analysis visualization, geospatial mapping, timelines, social network analysis (SNA), and other tools to find people trying to hide their identities and activities, Sentinel Visualizer maximizes the value of the data in your knowledgebase.
The article is entitled Building a Picture of the Bomb Suspects through Social Network Analysis. For more information, visit Building a Picture of the Boston Marathon Bombing Suspects through Social Network Analysis.
Microsoft Access Queries: Sorting on Multiple Date (or Numeric) Fields with Blank Values
Read our new paper, Microsoft Access Query Sorting on Multiple Date (or Numeric) Fields Containing Blank Values.
Learn how to sort on multiple date fields when null values exist by using a calculated field. By using the IIf and IsNull functions, you can easily sort to see the most recent (or oldest) records. Additional information and examples are provided to show why using the NZ function (NullToZero) is not equivalent and returns the wrong results. This new paper is part of our Microsoft Access Query Help Center.
Microsoft Access Shortcut Keys for Data Entry and Navigation
Updated paper on Data Entry and Navigation Shortcut Keys for Microsoft Access.
Learn these keystrokes to simplify your use of MS Access as a user or developer.
2013 Portland Oregon Microsoft Access User Conference
May 4-6, 2013
Silver Falls State Park, Oregon
FMS President Luke Chung was one of the featured speakers at this annual Microsoft Access conference hosted by the Portland Access User Group. This will be his third year speaking at this wonderful event. He enjoyed an amazing, rustic getaway to a beautiful state park with fellow Microsoft Access enthusiasts.
Luke participated in various talks on Microsoft Access development, running a business, and creating solutions using Visual Studio LightSwitch. He'll also be staying at the site during the entire conference.
For more information, visit the conference site.
Blaming Technology (Microsoft Access) Rather than Developer Incompetence
March 10, 2013
FMS President, Luke Chung, responds to a Washington Post article which described the experience of a local small business. They ran into trouble with Microsoft Access and were forced to migrate to another system. While there may be legitimate reasons to migrate, Microsoft Access took the blame for a poorly designed system which couldn't even support a trivial multiuser environment. The actual problem wasn't the technology, but the ignorance and incompetence of the developer who built that system.
Read more about it in the blog, Mistakenly Blaming Microsoft Access instead of the Developer.
Attending the Microsoft MVP Summit
FMS President, Luke Chung attended his first Microsoft MVP Summit at Microsoft Headquarters in Redmond, WA. Since the MVP program was created 20 years ago, FMS has had three other MVPs in the group. This was the first year Luke was added to the group. Here are some of his comments about the experience:
The MVP conference brings together 1500 professionals from across the world to this conference. The MVPs cover all the different product groups for Microsoft which offers a wonderful mix of expertise and enthusiasm.
Attending the Microsoft MVP Summit in Bellevue/Redmond, Washington.
Our Blog has Moved to WordPress
We've migrated our blog to WordPress from our previous BlogEngine.NET platform. We hope you like it.
WordPress has become the most common Blogging format, so we're happy to simplify the process for people to participate in our blog with their existing WordPress login. We also gain considerably more options for designing the layout of our blog.
We could have started our new blog from scratch but since our existing blog existed for many years, we wanted to migrate it with all the comments from our BlogEngine.NET host to WordPress. That turned out to be a challenge that required learning the idiosyncrasies of BlogEngine and WordPress. With the help of Microsoft Access, we created a table with the terms that needed to be translated, read the XML file from BlogEngine, then created a new XML file that WordPress would import.
For details of how we did it, visit
Migrating BlogEngine.NET Posts to WordPress
with Translations Using Microsoft Access.
New Paper on Microsoft Visual Studio LightSwitch for Microsoft Access, SQL Server, and Visual Studio .NET Database Developers
The Visual Studio team has introduced a development platform called LightSwitch which simplifies the creation of database applications in Visual Studio. This rapid application development environment lets you create solutions that can be easily deployed on Windows or Mac platforms from a public web site or Intranet.
We've been using LightSwitch for the past year and find it to be ideal for a particular class of SQL Server based solutions. Here our first article providing an overview of the benefits and limitations of the LightSwitch platform for the Microsoft Access community.
If you're interested in learning more about our help developing custom solutions based on LightSwitch, visit our LightSwitch Consulting page.
New York City Microsoft Access User Group Meeting
September 10, 2012
FMS President Luke Chung attended the New York Microsoft Access User Group Meeting. He was a featured presenter at the free New York City event hosted at Microsoft Headquarters located at 1290 6th Ave., between 51st and 52nd Streets. Luke discussed and demonstrated FMS products for Microsoft Access, Azure cloud computing, plus answered questions about his experiences.
For more information on future events, visit our Upcoming Events page!
Fixing the Microsoft Windows Common Control Library (MSCOMCTL.OCX) Security Update
August 14, 2012
On August 14, 2012, Microsoft released a security update that included an update to the Windows Common Control MSCOMCTL.OCX.
Unfortunately, this update causes problems with existing Microsoft Access applications that use the common control such as the Treeview and ListBox controls. This includes the Treeview used in the Database Explorer feature of our Total Access Analyzer program (when viewing the database documentation results).
Microsoft provides a workaround for this problem in a Knowledgebase article, but it doesn't always work. We've come up with a solution that addresses this problem reliably. Read our article onFixing the Microsoft Windows Common Control MSCOMCTL.OCX security update for more details.
New Version of Total Access Analyzer for Microsoft Access 2007 and 2003
Total Access Analyzer is the most popular Microsoft Access product of all-time! In conjunction with the release of the Microsoft Access 2010 version, we've added many of the new features to the Microsoft Access 2007 and 2003 versions.
In addition to the comprehensive documentation and analysis of your database objects, macros, and VBA module code, Total Access Analyzer version X.9 adds:
- Detection of Additional Errors and Suggestions
- Timer Interval and Timer Event Mismatch
- Queries Using Other Queries with Both having GroupBy Clauses
- Action Queries Opened by OpenQuery Command
- SQL Server list of reserved words updated for SQL Server 2012
- Displaying Additional Documentation Results
- ActiveX controls appear as a New Category under General
- New Table-Fields folder under Tables lets you view field properties across all your tables in one screen
- Enhanced Opening of Referenced Object in Design Mode (view the documentation and immediately jump to the object to make changes)
- Report Enhancements
- Preview Multiple Reports at One Time
- Color Customization for Reports
- Enhanced Macro Dictionary Report
- Many New Reports
- New Module VBA Documentation and Options for Microsoft Access 2007
- Advanced Macro Documentation and Analysis
- Temporary Variable Documentation and Analysis (TempVars)
- Improved User Experience
- Support for Windows 7 (in addition to XP and Vista) and Office Themes
- Installation options for the current user or machine, with support for User Access Control permissions
Existing customers with premium support subscriptions receive the upgrade for free. Other existing customers can upgrade for a nominal fee. Demo available.
Thank you for your support in making Total Access Analyzer such a great success!
Total Access Analyzer for Microsoft Access 2010 Update and Demo Version
Total Access Analyzer is the most popular Microsoft Access product of all-time! Documenting and analyzing your database objects, macros and VBA module code, Total Access Analyzer helps you understand what's going on. Take control of your MS Access applications and find errors and ways to improve their design and performance. Over 300 issues are pinpointed with 380 presentation quality reports for comprehensive documentation and cross-referencing of your application. Winner of every Best Microsoft Access Add-in award with great reviews, Total Access Analyzer remains the "Must Have" tool for serious Microsoft Access developers and people who inherit existing Access solutions.
What's New
- A demo version of Total Access Analyzer for Microsoft Access 2010 is now available
- An update, 14.01.0004, is available for existing owners with several enhancements
FMS President Luke Chung is a Microsoft MVP
July 1, 2012
Microsoft has officially recognized FMS President Luke Chung as a Microsoft MVP for his support of the Microsoft Access community.
Since the official launch of Microsoft Access, Luke Chung has been at the forefront of the Microsoft Access community (read his impression on the day Microsoft Access debuted). He has written numerous articles, spoken at conferences around the world, and collaborated with the Microsoft Access development team over the years. His leadership propelled FMS to the world's leading third party vendor of commercial products for Microsoft Access.
Congratulations Luke!
FMS Guest Blogs on the Microsoft Access Developer Blog
FMS developer Molly Pell is featured as a guest blogger on the Microsoft Access developer blog with two articles.
- Using a Combo Box to Search
- Microsoft Access Crosstab Queries in Reports
Using a Combo Box to Search
This post demonstrates a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box.
Check out the post here: Using a Combo Box to Search as you Type.
For more combo box tips, check out our Top 5 Combo Box Tips for Access.
Microsoft Access Crosstab Queries in Reports
This post demonstrates how to use the Pivot statement to control column names returned by crosstab queries, allowing crosstabs to be used on reports.
Check out the post here: Using crosstab queries in reports.
Or read our technical paper with a sample database: Creating an Annual 12 Month Summary Report without VBA Code by Creatively Using a Microsoft Access Crosstab Query.
Microsoft Access Database Architecture: Storing Temporary Data and User Settings
FMS President Luke Chung wrote a new paper, Microsoft Access Database Architecture: Storing Temporary Data and User Settings.
There are many things a user does with an application that need to be preserved either during processing, between screens, between sessions, or between application updates/versions. When designing a system, it's important to consider what to keep and where/how to do this. If designed properly, the data should also support multi-user environments.
Problem
Users are commonly annoyed to be forced to re-enter their last specifications when the application should start with that as its default. After all, a computer is supposed to be good at remembering things, right?
Solutions
There are several ways to preserve user information during a session, on a PC, and/or between PCs:
- Keeping Selections in Memory for the Current Session
- Using the Registry to Store User Information Between Sessions
- Using Private Tables to Store Information Between Sessions
- Making Sure Previous Values Remain Valid
Read the Microsoft Access Temporary Data paper for more details and tips.
New Presentation: Taking Over Legacy Microsoft Access Database Applications
May 2012
In May, FMS President Luke Chung presented at the three day Microsoft Access conference sponsored by the Portland Oregon Access User Group. Luke participated in a variety of discussions and gave a presentation on Taking Over a Legacy Microsoft Access Database Application. Check out the paper and PowerPoint presentation Microsoft Access Database Architecture: Storing Temporary Data and User Settings.
Situated at the beautiful Silver Falls State Park Conference Center, Luke and some fellow participants took a hike through forest and the many waterfalls there.
Space Shuttle Discovery Flies by Our Offices Three Times
April 17, 2012
The Space Shuttle Discovery on a 747 with fighter jet escort flies by our offices three times this morning. It banked right in front of our windows to head back to DC.
They eventually flew over us toward the Smithsonian's Udvar-Hazy National Air and Space Museum at Dulles Airport where it will be on permanent display.
See more pictures on our
Facebook album.
Total Access Analyzer for Microsoft Access 2010 Ships
The Microsoft Access 2010 version of Total Access Analyzer is now shipping with support for the 32 and 64-bit versions of MS Access 2010.
We've added many new features to support Access 2010, generate more useful documentation, identify more errors, and suggest more design improvements and best practices. There's advanced validation of macro commands, macro printouts showing indented syntax, temporary variable cross-referencing and verification, improved query performance analysis, etc.
We've also enhanced the user experience with the ability to open a cross-referenced item in design mode while viewing the information, previewing multiple reports at once, and adding color to all reports. Here is a description of the new Access 2010 features. Existing customers can upgrade at a discounted price.
Read more about Total Access Analyzer 2010 Press Release. Try the Free Trial today!
FMS Participates with Virginia Governor's Declaration of 2012 as the Year of the Entrepreneur
February 22, 2012
FMS President Luke Chung was invited by the governor's office to participate in his proclamation of 2012 as the Year of the Entrepreneur. Luke stood behind Governor Bob McDonnell and Lieutenant Governor Bill Bolling during the press conference and participated in a day-long event supporting entrepreneurship, small businesses, and job creation.
Commerce Secretary James Cheng led the events. Participants were able to hear from successful Virginia business founders and learn from each other through a luncheon and Entrepreneurial Town Hall. Examples of agricultural, technology, manufacturing, and craft businesses showed the diversity of Virginia firms offering products and services for in-state, national and international customers. It was also interesting to trace the roots of the founding of Virginia in 1607 as a high-risk entrepreneurial enterprise that eventually led to success after many failures.
For more information, read our
FMS Participates with Virginia
Governor's Declaration of 2012 as the Year of the Entrepreneur.
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."
Read the full review on our website.
Participating on the Senate Finance Committee's Small Business Roundtable
September 15, 2011
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
June 4, 2011
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
FMS President Luke Chung wrote a new
blog post 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.
To read the full article, visit our blog post Create a backup and Disaster Recovery Plan. 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
May 14-16, 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! For more information on future events, visit our Upcoming Events page.
Luke Chung Presenting at the Denver Area Access User Group
April 5, 2011
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
Denver, CO 80237
For more information on future events, visit our Upcoming Events page.
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
December 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. Try the Free Trial today!
Total Access Statistics for Microsoft Access 2010 is Now Shipping
September 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. Try the Free Trial today!
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.
- Microsoft Azure and Cloud Computing...What it Means to Me and Information Workers
A general overview of how he sees cloud computing impacting our industry. - Microsoft Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server
Tables in the Cloud)
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, 2010, but this version is good through September 1, 2010. We hope you get a chance to use it and provide feedback on what you discover.
Download the Total Access 2010 Preview Version today!
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, 2010.
Download the Total Access 2010 Preview Version today!
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.
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, and try the Free Trial today!
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.
For more information, visit 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!
For more information on future events, visit our Upcoming Events page.
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:
- Microsoft Access Performance Tips to Speed up Your Access Databases
- Microsoft Access Query Tips and Techniques
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).
The new 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 called 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. Visit the Microsoft Page.
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 Total Access Statistics and Total Access Admin.
|
|
|
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 for 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 updates 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
June 17, 2009
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 Washington DC Access SIG.
Online Video from the Microsoft TechEd Conference
Watch videos of Luke Chung's participation on the Microsoft Tech Ed Conference panels.
- Let's Talk about Software Consulting as a Business
- The World Turned Upside Down: Development Strategies for Lean Times
- Migrating Your Data Tier to SQL Server: Strategies for Survival
- The FMS Story: Surviving Uncertain Times: An Interview with Luke Chung
Luke Chung Speaking at Microsoft TechEd Conference
May 11-15, 2009
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
April 7, 2009
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. Download the Free Trial today!
Luke Chung Speaking at the Denver Access User Group
March 19, 2009
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/. For information on FMS participation in future events, visit our Upcoming Events page.
MSDN Channel 9 TV - Luke Chung on Microsoft Access Database and Migration Challenges
March 2, 2009
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 Microsoft Access Database and Migration Challenges Video (22 minutes) and read more about Migrating Microsoft Access Databases to SQL Server.
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.
Our team of expert technologists and business analysts continually hone their skills to maximize the impact of the technology. Please contact us so we can apply our experience and expertise to your needs.
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. For more information, visit New Features for Version X.8. 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. For more details, visit Error Pasting Data from Microsoft Excel 2007 to Microsoft Access. Learn more about the issue and a few workarounds that our FMS developers have found.
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!
To read more, visit Hot Mommas Project: GW's Sizzling New Research Initiative.
White Paper: Application Development During Uncertain Times
November 2008
Read FMS president Luke Chung's white paper, Application Development During Uncertain Times. 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. Microsoft made a big investment to create Access 2007 and added a lot of great new features with significant changes to
objects, properties, VBA code, the user interface, an entirely new database format, with new field types and embedded macros.
So we now support MDB, ADPs, and the new ACCDB database formats. The user interface can be in tabbed view or traditional windows. Layer on top of that the differences between Windows XP and Vista, and you'll quickly see the number of permutations our developers and QA staff needed to address.
For more information, visit New Features for Total Access Analyzer 2007!
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. Download the Free Trial today!
Free Seminar for Microsoft Access to SQL Server Upsizing Co-Sponsored by Microsoft in Reston, Virginia
June 27, 2008
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
For more information about the seminar, visit 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.
Watch the Microsoft Access to SQL Server Upsizing video for more details.
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. Download the Free Trial today!
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. For mroe information, visit Microsoft Developer Network (MSDN) Premium Subscriptions.
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. For more information, check out the Press Release on the release of Total Access Startup 2007.
See you in San Diego, California!
March 2008
FMS President 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, 2008, so make sure to stop by if you're there. For more details, visit our Upcoming Events page.
Total Access Admin 2007 Ships
February 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. Download the Free Trial today!
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 called Microsoft Access Help, Resources and Services from FMS. It includes a brief history of Access, our experiences with Access, links to technical papers, tips, and other resources.
New items include:
- Microsoft Access Error Numbers and Descriptions
List of all error numbers and descriptions for Access 2007 plus comparisons with previous Access versions. - FMS Access Products vs. User Category Matrix
An overview of FMS products to see how each product applies to your situation. - Microsoft Access Consulting Services
See how we can help you create great Access applications.
Free Book Offer for Microsoft Access 2007
Get the Access 2007 book, "The Rational Guide to Microsoft Office Access 2007 Templates" by Zac Woodall, 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, with the purchase of one of our Microsoft Access 2007 products.
For more information on this amazing deal, visit Free Book Offer!
New Technical Paper for Creating Monthly Summary Reports in Access
October 28, 2007
FMS President Luke Chung has written a new paper on how to create spreadsheet like reports with monthly summary columns without writing any code. For more information, check out Creating an Annual 12 Month Summary Report without VBA Code by Creatively Using a Microsoft Access Crosstab Query.
FMS Participating and Speaking at Advisor Summit in Miami, FL
September 30 - October 4, 2007
FMS President Luke Chung is speaking in the Microsoft Access track of this event. We will also have a booth among the exhibitors. For more information on FMS participation in future events, as well as other seminars and roundtables, visit our Upcoming Events page.
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. For more information, visit FMS Products for Microsoft Access 2007.
New Product - Sentinel Visualizer Version 4.0 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. Read more on Sentinel Visualizer Version 4.0 Release.
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.
Download the Free Trial today!
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. Download the Free Trial today!
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
April 10, 2007
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 more about FMS Awarded Microsoft Gold Certification.
FMS Free Links to Outside Resources
February 2007
Can't find what you're looking for on Microsoft Access, .NET, SQL Server? Visit our newly updated Microsoft Access and Office Links page and utilize the list of outside resources we've put together for your convenience.
FMS Upcoming Events
February 15, 2007
FMS is going to Disneyland! We hope to see you at the Advisor Summit on Microsoft Access and Office, on May 6-10, 2007 in Anaheim, CA. Stop by our booth and listen to FMS President Luke Chung speak about topics including:
- Where Microsoft Access fits in the Overall Database Strategy of an Organization
- Tips and Techniques for Taking Over an Existing Access Application
- Best Practices for Creating Great Access Applications
For more information on FMS participation in future events, as well as other seminars and roundtables, visit our Upcoming Events page.
Protecting our Children with the National Center For Missing and Exploited Children
January 20, 2007
We recently began working with the good people at the National Center for Missing and Exploited Children to see how we could help their efforts. We also learned a lot about how to better protect our children. Read FMS President Luke Chung's open letter on his experience.
Microsoft Featured White Paper, by Luke Chung
January 2007
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.
FMS Celebrates 20 Year Anniversary
October 26, 2006
Founded in 1986, FMS is celebrating its 20th anniversary in business. This proud achievement is a very significant milestone for us. Very few companies survive so long, much less firms in our rapidly changing technology industry. Our success over the years stems from properly serving our customers, employees, and vendors through many business and technology cycles. And, of course, the continued support our customers give us for our innovation and customer service, we thank you most of all.
FMS President and Founder Luke Chung has a message to celebrate FMS 20th Anniversary.
Total .NET SourceBook 2005 is Shipping
October 24, 2006
FMS releasedTotal .NET SourceBook 2005, the latest version of its best-selling professional source code library and code repository for Visual Studio .NET. The newest version supports Visual Studio .NET 2005 with a comprehensive collection of royalty free, ready-to-use .NET programming code in C# and Visual Basic .NET. For more information, visit New Professional Code Library for Visual Studio 2005.
New Versions of Total Access Analyzer Available
October 5, 2006
FMS, Inc. is proud to release new versions of Total Access Analyzer with many new features and enhancements. Version 11.7 is now available for Access 2003, Version 10.7 for Access 2002/XP, and Version 9.7 for Access 2000. Total Access Analyzer is the most popular Microsoft Access add-in winning every industry “Best Access Add-in” award since 1994. The new versions generate even more comprehensive documentation and analysis of Access databases to help users and developers create better solutions.
FMS President Luke Chung featured on Microsoft website
September 2006
FMS President Luke Chung is featured on Microsoft's Most Value Professional webpage. Learn when to use Microsoft Access and when to use SQL Server in your organization. This 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.
Newest Version of Total Access Emailer Available Today
July 15, 2006
We are excited to announce a new and greatly improved version of Total Access Emailer. Total Access Emailer is the leading email program for Access users and developers. Easily leverage the power of Microsoft Access and email to generate personalized text and HTML email for everyone in your table or query. Use field values from your Access tables and queries to create unique, personalized emails for each recipient. You can even maintain an audit trail to know who was contacted when. Download the Free Trial today!
Dot.net Magazine Awards Total .Net Analyzer
May 15, 2006
Dot.net magazine of Germany recently recognized Total .NET Analyzer as its Reader's Choice best software for testing, Q/A, and debugging! We are honored by this latest addition to Total .NET Analyzer's wide array of awards and rave reviews. Download a30-day Trial today and see how this award-winning product can improve your applications.
Total Access Statistics Updates Available
May 10, 2006
Total Access Statistics is the most powerful data analysis tool for Access. Total Access Statistics runs as an Access add-in and offers a wide range of statistical functions to analyze your data, including regressions, percentiles, ANOVA, t-Tests, and much more. You'll be amazed at the powerful statistical analysis you can generate within Access!
As part of our commitment to providing quality software, we have released update patches for Total Access Statistics 11.0, 10.5, and 9.5 (for Access 2003, 2002, and 2000 respectively). These updates resolve a few known issues in the products, and also include several new features. For more information, visit the Total Access Statistics Update page.
New Versions of Total Access Emailer Released
May 10, 2006
Total Access Emailer makes it easy to send personalized emails from within Access. With the release of the new X.5 versions for Access 97, 2000, 2002, and 2003, users can now use Total Access Emailer to embed access reports, tables, queries, and more! For more information on the new features, visit Version X.5. Try the Free Trial today!
Microsoft Small Business Specialist Designation
March 24, 2006
Microsoft has certified FMS as a Microsoft Small Business Specialist with experience and qualifications to address the needs of small businesses. Find out what we can do for your organization today.
SQL Server Upsizing
February 22, 2006
While many Access databases remain perfectly fine in Access, a certain number grow and evolve into applications that push the limits of Access. When is it time to grow into SQL Server? Visit the Professional Solutions Group, Upsizing page and discover why even Microsoft uses FMS data to decide when you should use a new solution.
FMS Featured in the Washington Business Journal
February 17, 2006
As recently featured in Washington Business Journal, the FMS Advanced Systems Group is leading the industry to go beyond traditional link analysis. Visit http://fmsasg.com and learn more about this exciting advancement in technology.
FMS Announces renewal of its Microsoft Gold Certification for 2006
February 15, 2006
Microsoft has renewed its certification of FMS as a Microsoft Gold Certified Partner. This is Microsoft’s highest partner certification level and reflects the proven experience and expertise of FMS for creating solutions using Microsoft technology.
Strategic Investment and Licensing Agreement with In-Q-Tel
October 14, 2005
As recently featured in Washington Business Journal, discover this new technology.
Steve Clark Designated Microsoft MVP
October 13, 2005
We are proud to announce that Steve Clark, Senior Project Manager, has been selected for the 5th straight year as a Microsoft Office Systems Access MVP. Each year Microsoft reviews the contributions of professionals around the globe to find the cream of the crop in dedication. In addition to being a consistent resource for Microsoft newsgroups, Steve has also been a contributing author to the Access 2003 VBA Programmer's Reference book published by WROX.
Get a Product Catalog Today
September 23, 2005
The new FMS product catalog is now available. Get to know some of the people that contribute to our success and all the latest products to "Accelerate" your work!
FMS Selected to Guest Speak at CIPS
September 21, 2005
The Canadian Information Processing Society has selected FMS to guest speak at the annual conference in Edmonton, Alberta, Canada, November 8th, 2005. For more information on FMS participation in future events, as well as other seminars and roundtables, visit our Upcoming Events page.
Pod Cast with Luke Chung
September 16, 2005
This interview featured Access through the eyes of long-time database veteran, guru, and FMS president, Luke Chung. This Pod Cast was courtesy of OfficeZealot.com.
FMS Moves
August 15, 2005
We are happy to announce that FMS has moved. Our new address is: 8150 Leesburg Pike, Suite 600, Vienna VA, 22182-2721. Phone, Fax, and Email information remains the same.
Case Studies
June 13, 2005
We enjoy sharing success stories with you. Here are 2 success stories we are proud to highlight. Office Tools Pro uses Total Access Memo and NGP Software, Inc. uses Total Access Agent. Share your experiences with us anytime.
Visual Studio Magazine
April 22, 2005
We are proud to be in the April issue of Visual Studio magazine, page 19, with a product listing forTotal .NET SourceBook - our code library product.
Total Access Ultimate Suite
April 13, 2005
All our 2003 products for Microsoft Access are now shipping, which includes the Total Access Ultimate Suite. If you're serious about Access, this suite is what you need for significant productivity! Amaze the boss and save $2000 today!
Total Visual SourceBook
April 12, 2005
Total Visual SourceBook is the most popular professional source code library for Access, VB, and VBA developers is now shipping with support for Microsoft Access/Office 2003, as well as Office 2000, Office 2002/XP, and Visual Basic 6. This new version includes browser enhancements to customize the error handling for the FMS procedures making it simple to replace the default error handling code, plus lots of new code. Over 85,000+ lines of code and 160+ classes and modules are available for you to use royalty-free in your applications!
Total Access Analyzer Recognized by Access Advisor
April 5, 2005
The new version of Total Access Analyzer is available and brings new functionality to help Access developers control their databases by understanding how they work.
Total Access Detective
March 18, 2005
Total Access Detective allows you to easily compare objects, properties, fields, controls, lines of code, data, and more to know exactly what changed! New features include combining data differences into a new table, summary reports for databases differences, support for ADPs, and much more! Versions available for Access 2000, 2002, and 2003!
Vote for FMS Development Tools
March 15, 2005
We are proud to have our products recognized in the development tools section of MSD2D's Fourth Annual People's Choice Awards.
Vote for any of our 3 products:
Now Shipping: Total Visual Agent
March 2, 2005
All Access/Jet databases need regular maintenance for optimal performance and bloat elimination. Total Visual Agent solves your administrative chores like compacts and backups by letting you schedule these and other repetitive tasks. Total Visual Agent can now run as a Windows NT Service which lets you manage ALL your Access/Jet databases across your network securely. Supports all versions of Access (including 2003), Jet, and Visual Basic. Download the Free Trial today!
New Training Video System
January 1, 2005
Master Microsoft Access, .NET, .ASP, C#, and Visual Basic with this easy-to-follow CD-ROM collection from Blast Through Learning, a company recognized throughout North America for world-class courseware and comprehensive training courses. Industry experts Dan Balter, Paul Sheriff, Alison Balter, and Bruce Jones lead you step by step through the intricacies of using these. We are confident you will find these videos very useful, plus they are nearly 30% off regular price. Order today!
Now Shipping: Total Visual CodeTools
December 8, 2004
The new Total Visual CodeTools is shipping! The new version supports Visual Basic 6, Access/Office 2000, Access 2002/Office XP, and Access/Office 2003. Integrated directly into the VB/VBA Integrated Development Environment, Total Visual CodeTools provides a rich set of coding tools. Total Visual CodeTools helps you increase productivity and ensure that your code is efficient and maintainable. Download the Free Trial today!
New Division at FMS
November 30, 2004
We are proud to announce the new division within FMS, the Advanced Systems Group. This new group is responsible for delivering advanced analytical software to a variety of missions. Visit FMS, Advanced Systems Group today!
MSDN Event in Southeastern Virginia
October 12, 2004
FMS recently exhibited at a MSDN seminar held in Chesapeake, Virginia. The event, attended by over 70 individuals, was a huge success for FMS, who was able to publicize products and services. For information on FMS participation in future MSDN events, as well as other seminars and roundtables, visit our Upcoming Events page.
Total Access Analyzer is Shipping
October 1, 2004
The most popular Access add-in of all time is now available for Access 2003, plus an updated version 10.5 supporting Access 2002. The new version offers over 200 "Best Practices" to flag errors, offer suggestions, and much more. Download the Free Trial today!
Featured on: Let's Talk Computers Radio Show
August 27, 2004
Luke Chung, FMS president and founder, discusses software tools that are available to developers. Listen to the recorded radio interview today.
Software Solution for City of Phoenix
August 13, 2004
The City of Phoenix has chosen FMS to provide operational consulting services and software support to its waste management department.
Sentinel TMS
July 10, 2004
Sentinel Threat Management System has recently been included in Microsoft's Justice and Public Safety catalog.
FMS and Council for Christian Colleges & Universities (CCCU)
June 29, 2004
Featured New Database System in Microsoft meeting.
Association Management Software
June 5, 2004
FMS delivers association management software for a major custom .NET application to manage memberships, relationships, and events for non-profit university organization headquartered in Washington D.C.
Total Access Emailer for Access 2003
April 19, 2004
"I recently purchased Total Access Emailer for Access 2003. I just want to say what a great program it is. We send invoices and dispatch data electronically (in text or Xml format) from our Access database. It used to be a rather cumbersome having to manually attach files that we had created using Access. Now, with just a click of a button, Total Access Emailer takes care of the entire process. Thank you!" - Phillip Kershaw, Triumph International (NZ) Ltd.
Now Shipping Total Access Statistics for Access 2003
April 16, 2004
Total Access Statistics for Access 2003 is now shipping with many new features and analysis types. New versions for Access 2000 and 2002 are also available with these enhancements.
Tech Deputies
April 14, 2004
Washington Business Journal reports: "Local firms capitalize on software that connects the dots for law enforcement. The heightened level of security has led to higher levels of government funding to fight terrorism, and officials with companies selling connect-the-dots software, such as Vienna-based FMS and Springfield-based i2, hope this will lead to increased demand for their products." - Neil Adler, Staff Reporter
Product Review for Total .NET Developer Suite
April 4, 2004
"The Total .NET Developer Suite looks and feels very much like it is OEM and not a third-party add-in." - Sanders Kaufman, Builder.com
Visual Studio Magazine Readers Choice Awards
March 29, 2004
FMS has received two, 2004 Visual Studio Reader's Choice Merit Awards. Total .NET SourceBook was recognized for Development Tools and Total .NET Analyzer for Performance, Profiling and Debugging Tools.
Get a FREE FMS Catalog Today
February 25, 2004
Our entire product line in one catalog. This issue includes the MSDN Universal Subscription for only $1,499 when you purchase any FMS Suite and after the Microsoft DVD rebate - regularly $2,799.
Now Shipping Total Access Emailer for Access 2003
February 24, 2004
Total Access Emailer lets users and developers create and send emails based on their data. Download the Free Trial today! Versions available for Access 97, 2000, 2002, and 2003!
Cast Your Vote Today!
February 13, 2004
The asp.netPRO First Annual Reader's Choice Balloting has begun! FMS is proud to be in the category of Add-in with Total .NET SourceBook and the Utility category with Total .NET Analyzer. Support asp.netPRO and FMS, vote today!
SD Times Highlights FMS .NET Tools
January 28, 2004
In the February 1st issue of SD Times, page 21, article titled "Building On .NET", features our very own Dan Haught.
MSDN Subscriptions - Huge Savings With FMS!
December 16, 2003
Purchase the MSDN Subscription from FMS and receive a $800 discount. And now for a limited time FMS will take an additional $200 off when you purchase the MSDN Subscription with any FMS Product Suite. Buy the Total .NET Developer Suite, Total Access Developer Suite or Total Access Ultimate Suite and pay only $1799 for the MSDN Subscription. That's $1000 in savings! (retail price $2799). Supplies are limited.
Technical Paper on Access
October 21, 2003
FMS President Luke Chung wrote a new paper called Database Evolution: Microsoft Access within an Organization's Database Strategy. Whether you use Access or not, you'll want to read this detailed paper exploring the role of Access (the world's most popular database) in today's rapidly changing IT environment. Written by FMS president Luke Chung, this paper summarizes our experience with the use of Access across enterprise of all sizes. Discover how the strategic and proper use of Access maximizes your ROI and gives your organization a competitive advantage. This paper also analyzes the power of database evolution and how you should embrace and anticipate its impact throughout your organization.
Product Feature for Total Access Emailer
October 10, 2003
In the October issue of Visual Studio Magazine, Total Access Emailer is featured.
Product Review for Total .NET XRef
October 9, 2003
In the November issue of Visual Studio Magazine, Total .NET XRef is presented in the First Looks section. "A cross-referencing tool such as Total .NET XRef can be vital to supporting large, complex systems, and a lifesaver when you maintain other people's code. You can make changes with fewer unintended side effects when you can see every place where the code uses a data item. If you work with heavily used module-level variables or find yourself changing frequently used methods, Total .NET XRef can help you avoid making serious mistakes." - Andy Clark, Reviewer
Customer Service
October 1, 2003
"Geez, Nifty Products (like the Code Libraries), Spiffy Customer Service, and Super Prices (Great Value to the End User)... No Wonder folks keep coming back to FMS! It *is* kind of amazing the ugly level of customer service that's out there... Which makes is all the more refreshing when we get to deal with folks like Jessica and FMS. Thanks Again!" - Kevin Keith
Microsoft Case Study Featuring FMS
September 25, 2003
Maintaining a Competitive Edge: Improving Business Process with the .NET Framework features FMS and client MediVia.
Product Review for Total Access Emailer
September 12, 2003
"Email jobs are saved so they can be edited and reused. You also get statistics and reporting after a blast has gone out. There's even a programmatic interface in case you'd like to add emailing capabilities to your own Access applications. All in all, a nice piece of work." - Mike Gunderloy, Developer Central 32
Total Access Emailer Highlighted
September 12, 2003
Total Access Emailer is highlighted in the product listing section of the October issue of Visual Studio Magazine.
Product Review for
Total Access Emailer
September 11, 2003
"FMS Total Access Emailer lets you generate personalized e-mail messages in text or HTML format for everyone in your table or query." - Advisor Zone
Product Review for
Total Access Admin
September 10, 2003
"The FMS Total Access Admin helps you perform tasks such as fixing database corruption and logging off idle users in order to perform maintenance." - Advisor Zone
Microsoft Approves Total Access Startup
September 9, 2003
Total Access Startup has been approved by Microsoft for quality standards and will now appear with the Microsoft "Designed for Microsoft Windows XP, 2000, ME, 98" logo. Discover this superior product today.
Total .NET SourceBook featured in Tool Gallery
September 5, 2003
Total .NET SourceBook is featured in the Visual Studio Magazine Tool Gallery. Discover more with Total .NET SourceBook today.
Total Access Startup Featured in 46 Advisor Publications
September 1, 2003
Total Access Startup is featured in 46 Advisor Zone publications including the Microsoft Access Advisor Zone. Use the tool to launch a database with the appropriate version of Access every time.
FMS, Microsoft Gold Certified Partner
August 24, 2003
FMS is now a Microsoft Gold Certified Partner, the highest designation for a Microsoft partner, and another example of FMS's commitment to deliver the best Microsoft solutions and services.
iX Magazine
August 20, 2003
The German Magazine iX plans to publish a list of tools for Microsoft .NET Framework 1.0/1.1. FMS is proud to announce our entire .NET product line has just been included in this special issue.
FMS Contributes to Advisor Magazine
August 19, 2003
In the September issue of Access-VB-SQL Advisor Magazine Troy Munford writes "Overcome a Common Access ActiveX Problem, Learn how linking tables at runtime affects ActiveX on forms and reports", page 22. Jim Ferguson writes "Avoid Unwanted Events in VB.NET", page 50. And Dan Haught has the Tip of the Month with "Decompile an Access Database to Improve Performance", page 50.
Product Review for Total .NET Analyzer
August 18, 2003
In the September issue of Visual Studio Magazine, page 11, "My favorite category is "Unused," which reveals unused assignments and variables—dead code that invariably winds up lying around once development is complete... The documentation is clear and thorough, and technical support is courteous and responsive. The tool had difficulty parsing one of my projects, and a friendly representative handled my call. Within a few days, FMS released a new version that fixed the problem." - Leonard Lobel
The .NET Developer's Journal 2003 Readers Choice Awards
July 18, 2003
The .NET Developer's Journal is accepting your votes for the 2003 Reader's Choice Awards until August 30th. Our products, Total .NET SourceBook and Total .NET Analyzer have been nominated in a number of categories. We would be grateful if you could take a moment and cast your vote for your favorite FMS .NET tool.
Product Update: Total VB Statistics
July 17, 2003
As part of our commitment to providing quality software, we have just released an update for Total VB Statistics 6.5. The latest version of Total VB Statistics is 6.5.5. Download the Free Trial today.
Product Update: Total Access Memo
July 15, 2003
As part of our commitment to providing quality software, we have just released an update for Total Access Memo 10 (for Access 2000 & 2002). The latest version of Total Access Memo 2002 is 10.01.0000. Download the Free Trial today.
Total Access Startup Highlighted
July 10, 2003
Total Access Startup is highlighted in the product listing section of the July issue of Visual Studio Magazine.
Product Review: Total .NET SourceBook
June 27, 2003
"Moving and copying code snippets around from the Sourcebook to your Visual Studio project and vice versa is, as they say, a breeze. I was very impressed with the way you can highlight a chunk of code in your project and simply drag it onto a node in the sourcebook to create a new sourcebook entry automatically. Very neatly done." - Ged Mead, DevCity.NET
Product Review: Total .NET Analyzer
June 20, 2003
Mike Gunderloy compares three .NET tools and says, "Of the products I’ve looked at here, Total .NET Analyzer takes the most detailed look at code from all angles of best practices."
Total .NET Analyzer Featured in Advisor Zone
June 15, 2003
Total .NET Analyzer featured in the Advisor Zone, Visual Basic .NET provides two options for casting. What you need to know to optimize your applications.
Total Access Startup Eases Deployment Feature
June 9, 2003
Access Advisor Update, Issue 2003 Week 24, features Total Access Startup. Use the tool to launch a database with the appropriate version of Access every time.
SD Times 100 Innovators and Leaders, Recognizes FMS
June 2, 2003
"The SD Times 100 looked for companies which set a direction that developers and the industry followed in 2002... When choosing the SD Times 100, we carefully considered each company's offerings and reputation, as well as the attention and conversion we've heard around the company and its products and technologies, as a sign of leadership within the industry." - Alan Zeichick, Editor-in-Chief of SD Times
Product Review: Total .NET SourceBook
May 29, 2003
"The entire tool is completely intuitive. It's a great training tool and has excellent potential for encouraging development standards. Total .NET SourceBook's simple elegance is impressive." - Andy Clark, Visual Studio Magazine Reviewer
Rave Review: Total Access Analyzer
May 27, 2003
"I have been a fan of FMS since about 1996 when I found your free 3D text add-in for Access 2.0!! I was in college at the time and found your site to be a fantastic resource for learning about Access. I currently use the Total Access Analyzer for Access 2002 here at work. It's awesome." - Dave Totzke, Andrés Wines Ltd.
Microsoft MVP Using Total Access Analyzer
May 16, 2003
"I had four Access 2000 databases with linked tables to SQL Server 2000. Each database had some 60 forms, 80 ODBC linked and/or local tables, 200 queries, and around 100 reports each. I needed to clean up and combine these database front-ends and their respective SQL back ends. I don't know if I would have accomplished this with out using Total Access Analyzer. With the use of this tool I was able to clean up the VBA in all modules (get it to a compiled state). I was able to cross reference every object in the database (down to the field) such that I could find and remove unused objects and or correct errors. The product is great!" - Dave Patrick, Microsoft MVP Windows NT/2000 Operating Systems
Total Access Startup Featured in Advisor Explorer
May 15, 2003
In the current issue of Advisor Explorer, Total Access Startup is featured in the Technology News section.
FMS is a Proud Sponsor of Utter Access.com
May 14, 2003
Visit an incredible forum site for discussion on Microsoft Access, Visual Basic, SQL Server, Office and .NET.
FMS and Microsoft form Access to SQL Server Migration Services
May 12, 2003
The campaign has begun, "FMS has a great history of successfully migrating Access applications over to SQL Server... We knew we wanted a partner with a strong reputation for these service deliveries, so FMS was a natural choice for us." - Adam Carroll, SQL Server Product Manager at Microsoft.
Total Access Admin Featured in Advisor Explorer
May 5, 2003
In the current issue, Total Access Admin is featured in the Technology News section.
Product Award Nomination: Total .NET SourceBook
April 28, 2003
.NET Developer's Journal has listed Total .NET SourceBook as a nomination for their 2003 Reader's Choice Awards.
Total .NET SourceBook for Microsoft .NET
April 24, 2003
"Developers using Visual Studio .NET 2003 have a dependable resource with FMS... Developers using the Total .NET SourceBook for Microsoft .NET will experience greater productivity with a better understanding of the application before deployment." said David Lazar, Director for the Developer and Platform Evangelism Division at Microsoft Corp.
Product Review: Total .NET SourceBook
April 21, 2003
"The mother of all Visual Studio code libraries...they're going beyond code, the first round of downloads included some hints for working effectively with VS .NET and a white paper on macros." - Mike Gunderloy, MCPmag.com
Database Evolution - Guest View In Advisor Magazine
April 17, 2003
Luke Chung, FMS President, discusses database evolution - Microsoft Access in an organization's database strategy.
Product Review: Total Visual SourceBook
April 16, 2003
"Total Visual SourceBook has saved me hours because I don’t have to hunt for older code snippets and am able to employ its vast code library. Total Visual SourceBook can help VB developers keep better track of their code without blowing their budgets." - Brian Kennemer, Builder.com
Get Queries to Run Properly in Access
April 15, 2003
In the May 2003 issue of Access-VB-SQL Advisor, page 24, FMS's own Steve Clark, Project Manager, discusses how to migrate non-normalized data to a normal form in Access.
New Release: Total Access Startup
April 10, 2003
Total Access Startup is now available! Total Access Startup eases the deployment and management of Microsoft Access databases. With Total Access Startup, you can launch your database with the appropriate version of Access every time. Download the FREE Trial today!
Product Feature: Total SQL Analyzer PRO
March 28, 2003
In SQL Server Magazine March issue, Total SQL Analyzer PRO is featured as the software that can document and analyze your database performance and detect design problems on page 9.
Product Features In Visual Studio Magazine Directory
March 24, 2003
In the Visual Studio Magazine 2003 Buyers Guide & Product Directory, both Total .NET SourceBook & Total .NET XRef are featured on page 28. Total .NET Analyzer is featured on page 37. FMS is also featured as a VSIP partner on page 44.
Total .NET SourceBook Featured
March 12, 2003
Stephen Swoyer features Total .NET SourcBook in the Enterprise article.
Product Update: Total SQL Statistics
March 5, 2003
The update patch and new trial for Total SQL Statistics are now available.
SD Times Announces Total .NET Developer Suite
February 28, 2003
In the March 1st issue of SD Times, page 8, Alan Zeichick announces Total .NET Developer Suite. Buy the suite and save big.
Product Feature: Total Access Speller
February 24,2003
In the March issue of Access-VB-SQL Advisor Magazine, page 57, Ken Getz discusses Total Access Speller, an add-in that can help developers catch spelling errors.
Total .NET Developer Suite "Essential Resource"
February 11, 2003
"FMS is providing Visual Studio .NET 2003 developers with an essential resource... Development teams using the Total .NET Developer Suite will experience greater productivity by identifying application development issues before deployment." - David Lazar, Director of the Developer and Platform Evangelism Division at Microsoft Corp.
New Versions for Visual Studio .NET 2003
February 4, 2003
Now available, new versions of Total .NET Analyzer, Total .NET SourceBook, and Total .NET XRef! These 1.1 versions fully support the new Visual Studio .NET 2003 (Everett). Download the FREE trial versions today! Order today and receive BOTH, the 1.1 version (2003) and the 1.0 version (2002)!
New Release: Total Access Admin
January 29, 2003
Total Access Admin is now available! Total Access Admin offers total maintenance control of your Access/Jet databases. Simply start the program, point to your database, and take control.
New Release: Total .NET SourceBook
January 17, 2003
Total .NET SourceBook is the Ultimate Code Library for .NET. Get a jumpstart into .NET with thousands of lines of C# and Visual Basic .NET code. Hundreds of categories, samples, tips, and how-to's make .NET coding a snap.
eWeek Announces Total Access Startup
January 7, 2003
In the January 6, 2003 issue, page14, eWeek announces the new FMS Total Access Startup. The new product sets Access database options and enables distributed deployment of applications. More details on this product coming soon.
Case Study of Total .NET XRef
December 31, 2002
Cross-Reference Tool Eliminates Confusion - Knowing How Code Is Used Makes Changes More Dependable. This case study features BizIntegrity using Total .NET XRef.
"Total .NET XRef is an absolute life saver" - Jeff Lynch, BizIntegrity
Review for Total .NET Analyzer, Code Critic
December 17, 2002
In the January 2003 issue of Software Development, Rick Wayne reviews Total .NET Analyzer on page 20.
"...It's a great way to pick up some of the best practices in .NET coding" - Rick Wayne, Software Development
MSDN Flash Presents Total .NET SourceBook
December 16, 2002
This addition of MSDN Flash announces Total .NET SourceBook in the Products and Technologies section.
Review for Total .NET SourceBook One Place For Everything
December 12, 2002
"Previous SourceBook products from FMS have been very useful, and this looks like another fine addition to the line." - Mike Gunderloy, MCPmag.com
New Microsoft Case Study with FMS Project
December 11, 2002
Omnicom delivers an industry-changing distribution channel for the promotional-products business with Tic Toc Marketplace on the Microsoft site.
Product Review for Total .NET Analyzer by Analyzer That
November 29, 2002
"FMS has a long track record of delivering excellent value to Microsoft Access and VB developers. It looks like they'll be keeping this up with .NET developers." - Mike Gunderloy, MCPmag.com
FMS Initiates Growth Plan in Consulting
November 4, 2002
FMS hires new vice president, Bill Robinette, to take the lead for consulting growth.
Luke Chung Featured in 10th Anniversary of Access
October 24, 2002
Access is now the world's leading desktop database solution, used by millions of people worldwide. Microsoft created a 10 year birthday web page for Access. Another Access addition is the MSDN Access Developer Center. We are proud to announce that three of Luke Chung's technical papers were recently published on that site.
Total .NET Analyzer is Now Shipping!
October 22, 2002
Use Total .NET Analyzer to scan all your projects for errors, performance, security and standard issues.
Visual Studio Wire Features Total .NET Analyzer
October 15, 2002
Visual Studio Wire announces Total .NET Analyzer.
Visual Studio Magazine Reviews Total SQL Statistics
October 7, 2002
In the November issue of Visual Studio Magazine, Total SQL Statistics is reviewed on page 17.
"Total SQL Statistics can help your VB application deliver data quickly from your database to your consumers without having to re-enter or transform it." - John Pearson, Visual Studio Magazine
Total .NET Analyzer Featured On Microsoft VSIP Site
September 30, 2002
Total .NET Analyzer is featured on the Visual Studio .NET Partner Resources main page.
.NET Framework Supported by FMS Products
September 16, 2002
"The FMS Total .NET product line is a valuable resource for Microsoft .NET developers targeting mobile development," said David Rasmussen, lead product manager for .NET mobile developer technologies in the Developer Platform and Evangelism Division at Microsoft Corp.
"Microsoft is pleased to be working with FMS to offer customers an easy-to-use computing experience that will enable developers to take advantage of the dedicated resources of Microsoft .NET."
SD Times Features Total .NET Analyzer
September 15, 2002
.NET Analyzer Checks C#, VB.NET Code by Christina, M. Purpi appears in the Software Development Times, September 15, issue, page 15.
Builder.com Reviews Total Visual CodeTools
September 9, 2002
"I like this product. It has helped me write more readable, maintainable code, and it basically taught me ADO database programming." - Brian Kennemer
Visual Studio Magazine Features Total SQL Statistics
September 6, 2002
In the October issue of Visual Studio Magazine Total SQL Statistics is featured in the Product Listings section, page 21.
Visual Studio Magazine Reviews Total .NET XRef
September 5, 2002
In the October issue of Visual Studio Magazine Total .NET XRef is presented in the First Looks section, page 19.
"One nice feature of XRef is its ability to find any object," said Dianne Siebold. "XRef is useful for speeding up development in enterprise projects."
MSDN Flash Presents Total .NET Analyzer
September 4, 2002
Volume 6, Number 9 announces Total .NET Analyzer in the Products and Technologies section.
MSDN Subscriptions Are Available Here
September 3, 2002
Now you can join the Microsoft Developer Network at a savings. Subscriptions and renewals are available today.
C/C++ Users Journal features Total .NET XRef
August 27, 2002
In the New Products section: FMS Releases Total .NET XRef, August issue, page 57.
Smart Access Reviews Total Visual CodeTools
August 19, 2002
"If you've never been good about coding standards, or your good intentions are sometimes sacrificed when you're working in crunch mode, then you owe it to yourself to check out Total Visual CodeTools, a great set of coding tools." - Danny Lesandrini, August issue, page 17-18.
Windows Developer Features Total SQL Analyzer PRO
August 15, 2002
New product announcement in the August issue, page 52.
Microsoft Office Solutions Magazine Reviews Total Access Speller
July 30, 2002
"It's entrepreneurship at its best: A company listens to users' complaints about a weakness in a popular program, and then the company provides a solution. That's exactly what FMS, Inc. has done for Microsoft Access database developers with Total Access Speller." - Faithe Wempen, August issue, page 37-38.
Advisor Magazine Reviews Total Access Speller
July 18, 2002
"If you're worried about the spelling on your Access database interface objects, check out FMS Total Access Speller...you'll have no problem figuring out how to use the program." - Crag Bobchin, Contributing Writer, August issue, page 38-39.
Advisor Magazine Publishes Rob Mastrostefano
July 17, 2002
The August issue contains Create a Page Indicator Component on page 18. Rob Mastrostefano is a senior system analyst with FMS and a member of the consulting team that develops custom software solutions.
Advisor Magazine Reviews Total .NET XRef
July 16, 2002
"I found this is a tool of the same FMS quality developers have come to rely on...it sure is nice to have in my toolbox." - Thomas Wagner, August issue, page 38.
Smart Access Features Total Access Detective
June 19, 2002
"If you're working on a whole bunch of databases and need help keeping track, this one is for you." - Smart Access eXTRA, Issue 3.6
Microsoft Office Solutions - Total Access Components
June 5, 2002
Total Access Components for Access 2002 is featured in the June issue of Microsoft Office Solutions Magazine, page 6, in the Toolbox section.
MCP Magazine Features Total Access Detective
June 5, 2002
Mike Gunderloy provides a nice review of Total Access Detective 2002.
Advisor Magazine Features Total Access Detective
June 3, 2002
Track changes in Access 2002 with Total Access Detective - June 2002 issue.
Windows Developer Announces FMS Total .NET Line
June 1, 2002
The Windows Developer Magazine, June 2002 issue, announces the entire FMS Total .NET product line.
Pinnacle Publishing Adds Total .NET XRef
May 31, 2002
Pinnacle Publishing adds Total .NET XRef to their .NET Developer Store.
Total SQL Analyzer PRO Reviewed
May 23, 2002
Sid Singer of Database Developers Group reviews Total SQL Analyzer PRO. "I found the detailed listing of scripts for all database objects, along with issues for each, to be an invaluable documentation guide to the database design features. Another favorite is the dependencies report, which illustrates all the relationships among the objects in the database." - Sid Singer, Database Developers Group
SQL Wire.com Announces Total SQL Analyzer PRO
May 17, 2002
Total SQL Analyzer PRO - the enhanced version of its predecessor.
MSDN Magazine Announces FMS .NET Products
May 16, 2002
In the June 2002 issue, section "NEW STUFF", page 11 - FMS rolls out five new developer products for Visual Studio .NET.
dotnet infowire.com Announces Total .NET XRef
May 15, 2002
Dotnet Infowire.com announced Total .Net XRef.
asp.netPRO Magazine Announces FMS .NET Products
May 14, 2002
FMS offers five new developer products for Visual Studio .NET. - asp.netPRO May 2002 issue, page 56
Total SQL Analyzer Gets 5 Star Review
May 13, 2002
"Total SQL Analyzer is a unique tool with a great price...Building on 15 years of experience, FMS continues to deliver outstanding bang-for-the-buck development tools. I highly recommend this product." - Thomas Wagner, asp.netPRO Magazine, Star Review, June 2002 issue, page 56.
MCP Magazine Reviews Total .NET XRef
May 1, 2002
"The end result is a tool that you can just use, as if it had been built in all along. And after a while you'll wonder how you did without it." - Mike Gunderloy, MCPmag.com
Windows Developer Magazine Announces FMS Products
April 29, 2002
Total Visual Agent, Total Access Components, and Total Access Statistics were listed in the "New Products" section of Windows Developer Magazine, May 2002 issue, page 68.
Total Access Analyzer Reviewed
April 25, 2002
"Total Access Analyzer is the most thorough solution for completely documenting Access databases." - Mike Gunderloy, Smart Access eXTRA, Issue 3.2
VBXtras Publishes Dan Haught's Article
April 19, 2002
Creating High-Resolution Times with Total Visual SourceBook.
Advisor.com Features Total Access Detective
April 18, 2002
Track changes in Access 2002, as well as discrepancies in different versions of your database.
C/C++ Magazine Announces Product Release
April 15, 2002
In the May 2002 issue of C/C++ Magazine, Total Visual Agent is announced on page 59, in the "New Products" section.
asp.net PRO Magazine Published Dan Haught's Article
April 11, 2002
In the April 2002 issue of asp.net PRO Magazine, Designing Commercial Web Services: Part 2, Versioning and Client Support with the .NET Framework on page 52, in the "asp:feature" section.
Visual Studio Wire.com Posted Total .NET XRef Release
April 10, 2002
Total .NET XRef - New Software is now available!
Total .NET XRef Now Available
April 4, 2002
Cross reference code on demand with Total .NET XRef.
"It is blazingly fast...I was completely astonished at the speed of this tool." - Thomas Wagner, eTechPartner, Inc.
SQL Server Magazine, April Issue
April 3, 2002
Analyze Stored SQL Server Data, page 12 - Total SQL Statistics
Total Access Analyzer Reviewed
April 2, 2002
"Total Access Analyzer remains one of the most essential add-ins on the market for the serious Access developer." - Mike Gunderloy, Microsoft Online Certified Professional Magazine
Smart Access eXtra issue 3.3, from Pinnacle Publishing
March 27, 2002
Announces Total SQL Analyzer PRO, Total Access Analyzer, Total Access Detective and Total Visual Agent are all available.
Total SQL Analyzer Reviewed
March 19, 2002
"I can envision how great this tool would be to provide clients with detailed documentation of their servers and databases. Overall, TSA fills a glaring hole in the existing SQL Sever toolset and is easy to use." - Dianne Siebold, Visual Studio Magazine
SQL Server Magazine March Issue
March 18, 2002
New Product, Developer Tool, page 10 - Total SQL Statistics
DNJ Post Total .NET XRef to their Site
March 14, 2002
Visualize your C# and VB.NET code.
Microsoft Office Solutions Magazine March Issue
March 13, 2002
In the "Tool Box" section, page 6. Two new products, Total Access Speller and Total SQL Statistics are featured.
Total Visual Code Tools Reaches MSDN April Issue
March 12, 2002
Define Enterprise-wide Coding Standards.
Total SQL Analyzer PRO is Available
March 11, 2002
The Total SQL Analyzer PRO version is now available. To see what's new, visit Total SQL Analyzer PRO.
All 2002 Access Products Are Now Available
March 11, 2002
Our Access 2002 products are now available, including Total Access Analyzer!
Total Access Detective for Access 2002 is Shipping
March 6, 2002
Find differences between objects and databases. Great for multi-developer and multi-version environments.
Total Access Speller Reviewed
March 6, 2002
"Some tools save you time; some save face. The way I figure it, avoiding personal embarrassment in front of my clients makes this product worth the price." - Danny J. Lesandrini, Pinnacle Publishing.com, March 2002 issue.
FMS Products Win Awards from Visual Studio Magazine
March 4,2002
Visual Studio Magazine Reader's Choice Merit Awards for Total VB Statistics - Data Analysis Tool and Total Visual Agent - Middleware and Data Connectivity.
Total Visual CodeTools Reviewed
February 28, 2002
"With Total Visual CodeTools, you can slip standards in as part of a productivity tool set - and expect that people will actually conform. Also, worth a look if you ever expect to go back and try to maintain your won code. Don't overlook the Help file either - rather than just describing the product, it's also got a long and useful section on VBA best practices." - Mike Gunderloy, Smart Access eXTRA, issue 3.2.
Alison Balter's New Book is Out
February 27, 2002
Alison Balter's Mastering Access 2002 Desktop Development
"The Total Visual SourceBook is any developer's best friend. The code library alone is worth many times the price of this tool. This tool goes a long way toward promoting reuse and consistency within a development environment." - Alison Balter
Total Visual SourceBook Reviewed
February 19, 2002
"The thing is, there are many times where code must be used to make one’s application do something different and that is when you will really appreciate the brilliance of Total Visual Sourcebook." - Graham J. Hadlington, Helping Hands, UK
VSLive Exhibitor
February 14-16, 2002
San Francisco, CA
Five New Products for Visual Studio .NET
February 13, 2002
"Microsoft, in combination with FMS is delivering an easy-to-use computing experience that will enable customers to take advantage of the next generation of
the Web," said David Lazar, group product manager for the Developer and Platform Evangelism Division at Microsoft Corp.
"The FMS product line for Microsoft .NET will be an extremely valuable set of products for our mutual customers."
First .NET Preview Version - Total .NET XRef
February 12, 2002
It is here! Download this incredible preview version today and put it to work on your Visual Studio .NET projects.
Total Access Statistics Reviewed
February 6, 2002
Microsoft Online Certified Professional Magazine reviews Total Access Statistics for Access 2002.
"If you're doing any sort of scientific or engineering number-crunching and your data is available to Access (either as native Jet data or as linked tables), TA Statistics can save you a bunch of work." - Mike Gunderloy, MCP Magazine Newsletter
Total Visual Developer Suite Now Available
January 30, 2002
The Total Visual Developer Suite includes Total Visual SourceBook and Total Visual CodeTools, with new support for Access 2000/2002, Office 2000/XP and Visual Basic 6.0
Total Access Speller Reviewed
January 29, 2002
Smart Access eXTRA issue 3.1.
Four New .Net Programs That Significantly Enhance .NET
January 29, 2002
Developers can create applications faster, analyze and cross-reference code, simplify development efforts, and improve the quality of their results with our productivity products.
Total Visual SourceBook Now Available
January 28, 2002
New Support for Access 2002, new code for ASP and more!
Total Visual CodeTools Now Available
January 22, 2002
Total Visual CodeTools for Access 2000/2002 and Visual Basic 6.0 is now available.
SD Times Newspaper Writes On Total SQL Statistics
January 15, 2002
asp.net PRO Magazine Published Dan Haught's Article
January 15, 2002
Designing Commercial Web Services: Part 1, Security and Flexibility with the .NET Framework.
Total Access Speller Now Available for Access 2002
January 14, 2002
You check and re-check and make sure every button works, and every report is complete and understandable. The big day comes. You demo your application to users, or send reports out to the company. And all that people remember is the spelling error that you missed.
Total Access Analyzer Reviewed by Swynk.com
January 10, 2002
Total Visual Agent Reviewed by Microsoft Online Certified Professional Magazine
January 9, 2002
"Jet is pretty well ubiquitous for those of us who use Microsoft operating systems, but it's often viewed as a toy database. By using Total Visual Agent, you can add professional data-integrity features to your Jet-based applications. The peace of mind and the safety of critical backups make it worth spending the money." - Mike Gunderloy, Microsoft Online Certified Professional Magazine
Total SQL Statistics Listed on SQL WIRE.COM
January 2, 2002
Total SQL Statistics VB.NET Advisor Tech News
December 31, 2001
Total Access Speller Now Available for Access 2000
December 27, 2001
You check and re-check and make sure every button works, and every report is complete and understandable. The big day comes. You demo your application to users, or send reports out to the company. And all that people remember is the spelling error that you missed.
Total Access Speller Now Available for Access 97
December 24, 2001
You check and re-check and make sure every button works, and every report is complete and understandable. The big day comes. You demo your application to users, or send reports out to the company. And all that people remember is the spelling error that you missed.
Total Access Memo Now Available
December 21, 2001
New Support for 2002! Robust and Professional rich text formatting - Now with full justification of text!
Total SQL Analyzer Gets Software Spotlight
December 12, 2001
Automate the documentation of SQL Server using Total SQL Analyzer. SQL Sever Performance.com gives Total SQL Analyzer the Software Spotlight!
Total SQL Analyzer Gets Another 4 Star Review
December 12, 2001
"Total SQL Server Analyzer is an invaluable tool that can save you time in preparing documentation, whether for Business Analyst, customers, or for disaster recovery preparedness. The documenting engine outputs data that is gold to me because I don't have to spend the days it would take to generate it. It lets me spend those days performing better uses for my time." - Brian Knight, SQL Server Central.Com
Total SQL Statistics Now Available
December 11, 2001
Powerful Number Cruncher for SQL Server and .NET Ready!
Total Access Statistics Now Available
December 5, 2001
New Support for 2002! The most powerful data analysis program for Microsoft Access.
Total Visual Agent Now Available
December 4, 2001
Automate maintenance chores for your Access/Jet databases: Automate backups, compact/repairs, repetitive tasks, and much more.
Total Access Components Now Available
November 28, 2001
27 ActiveX controls written specifically for Microsoft Access: supercharge you forms and reports, and simplify programming.
DNJ Reviews Total SQL Analyzer
"If you want to keep your database running efficiently, Total SQL Analyzer could provide the answer." - Kay Ewbank
Smart Access Reviews Total Access Analyzer 9.5
November 2001
"This is one Access utility that's worth the money", said reviewer Danny Lesandrini.
On the Radio
October 27, 2001
On the October 27 radio broadcast of "Let's Talk Computers", Luke Chung, FMS President, discusses changes in the computer industry and the 15 year anniversary of FMS.
Total SQL Analyzer Gets 4 Stars
"I hate documenting things as much as anyone, but I recognize the value and try to spend time working on it. I was excited to see a product that would ease the burden of documentation." - Steve Jones, SQL Server Central.com
Microsoft Selects FMS as Visual Studio Partner
FMS is selected by Microsoft as a Visual Studio Partner.
FMS Now Offers ESD
September 28, 2001
FMS, Inc. has announced the availability of ESD, Electronic Software Distribution, for its line of award winning products. Through ESD, customers no longer have to wait for their FMS product packages to be mailed to them but can quickly purchase and safely download them electronically. Customers will also save money by avoiding shipping costs – especially important for those overseas who find themselves frustrated with customs expenses.
For more information, visit FMS offers Heightened Convenience with ESD!
FMS President Gives Radio Interview for Entrepreneurs Group
Entrepreneurs Tour of America. Find out more about the man who started it all, and how FMS was built slowly and carefully over 15 years. No overnight, get rich quick scheme here!
You will need a FREE Real Player 8 Basic to hear this radio show interview.
FMS Wins Advisor Magazine Editors' Choice Awards
Total Access Analyzer, Total Access Components, and Total Visual CodeTools won Gold Editors' Choice Awards.
Total Access Analyzer
Best Access Add-In |
Total Access Components
Best Access Add-In |
Total Visual CodeTools
Best Visual Basic Add-In |
angryCoder.com Reviews Total SQL Analyzer
"It's greatest strength lies in preserving a set of document snapshots for database object comparison over time." - Danny J. Lesandrini
Total SQL Analyzer Is Now Shipping!
The world's first professional documentation and analysis program for Microsoft SQL Server. Now you finally can take control of SQL Server with Total SQL Analyzer.
New FMS Products For Microsoft Office XP
May 31, 2001
FMS is pleased to announce support for Microsoft Office XP and Access 2002. FMS currently offers an award winning family of eight products targeted for Access and Office users and developers.
Total Visual Developer Suite 2000 Reviewed
March 2001
"Every time I look at the package with the little blue-and-green tag reading "What's your time worth?" I think about the thousands of lines of ready-to-use code that come with it. I must say that on more than one occasion Total Visual SourceBook has made the difference between a marginally profitable project and a soundly profitable one. I cannot imagine any VB programmer who could live without this excellent tool." - Thomas Wagner of MS Office Deployment and Development
Total Visual Developer Suite 2000
Microsoft Office Deployment and Development Conference
April 8-12, 2001
Orlando, FL
Exhibitor
Speaker - Luke Chung, FMS President, answers Access questions and
demonstrates FMS products for Access
VBPJ 2001 Readers Choice Award
Total Visual Agent 2000 voted the Readers Choice Award for Best Middleware & Data Connectivity.
We Want Your Input
Our continued efforts to improve are still strongly focused on customer feedback. Please take a minute to compete our new purchase survey and tell us how we are doing.
VSLive/VBITS
January 13-20, 2001
San Francisco, CA
Exhibitor
Speaker at Tools Track
FMS Visits NYC
January 8, 2001
Access SIG, New York, NY
Speaker, Luke Chung, President.
For more information, visit our Upcoming Events page.
Total ZipCode Database Released
January 2, 2001
The entire USPS 5-digit zip code database with corresponding city and state names. Includes monthly subscription updates. Enter a zip code and go!
Introducing the FMS Community Newsgroup
Get involved in the community. Do you have a question or need product support? Discuss the solution while you gain knowledge on the FMS Community Newsgroup site. We've improved everything to better communicate with you.
VB Tips & Tricks Reader Choice Awards
Total Visual SourceBook 2000 was voted "Most Popular Programming Component" while Total Visual CodeTools 2000 received Straight A's in its categories.
Learn more about our Award Winning Products!
Microsoft Access Dev Con 2000 Pinnacle Awards
FMS collected seven awards during the DevConnections 2000 conference in New Orleans. Jointly sponsored by DevConnections and Pinnacle Publishing, these awards recognize excellence in third party tools and are chosen by developers like you who really use and know the tools.
Learn more about our Award Winning Products!
On the Radio
On the August 12 radio broadcast of "Let's Talk Computers", Luke Chung, FMS President, discusses FMS and ways to develop Visual Basic applications more efficiently with FMS products.
Access 2000 Suites Released
Serious Access developers should get our award-winning products in suite bundles to save time and money! Now available for Access 2000.
Visual Basic Suites Released
Visual Basic developers can now get our award-winning products in money saving bundles! Designed for individual developers and development teams, these suites will save you time and headaches!
FMS President takes the reins at Young Entrepreneurs' Organization
FMS President Luke Chung is now serving as president of the Washington, DC chapter of the Young Entrepreneurs' Organization (YEO). YEO is a global, non-profit, educational organization that helps its 3500+ members build upon their successes through an array of learning and peer-to-peer support opportunities.
Total Visual CodeTools 2000 Released
Increase your productivity and let your entire development team share and enforce a consistent set of coding standards. Supports Access/Office 2000 and Visual Basic 6.0
Total Visual SourceBook 2000 Released
The Ultimate Code Library for Developers, Teams and Enterprises! Supports Access/Office 2000 and Visual Basic 6.0
Total Access Components 2000 Released
The only collection of custom controls designed specifically for Access. Easily add new power and functionality to your Access applications.
Total Access Analyzer 2000 Released
Winner of every Best Access Add-in award since 1994. Total Access Analyzer 2000 is now available.
Total Visual Agent 2000 Reviewed
"It's not very often that one runs into a product that is useful to
so many members of an IS team. A network administrator can use it, because
data backup is typically something assigned to this person; a corporate
developer or DBA can use it to maintain Jet databases in their optimal
state; and a consultant can use its e-mail notification capabilities. It's
so easy to run that, in a pinch, even a power user can use it. Total
Visual Agent is a real find, a rare combination of ease of use, and "bang
for the buck." In the end, no other competitor even comes close!"
- Thomas
Wagner, MS Office and VBA Developer
Total Visual Agent 2000
FMS' Database Maintenance Tool
May 2000, MS Office & VBA Developer, pp. 58-59.
Total Access Memo 2000 Released
Only Total Access Memo 2000 gives you the power to add full formatting to your rich text data! Our super-easy data binding means the you can integrate rich-text right into your existing tables.
Total Access Statistics 2000 Released
The most powerful data analysis program for Microsoft Access is now available for Access 2000. Perform a wide range of statistical analysis on your databases.
Total Access Memo 2000 Recommended by Microsoft
Microsoft reports a bug in Access 2000 that they say can be resolved by using FMS' Total Access Memo 2000! According to Microsoft, you cannot see the contents of an embedded Microsoft Rich TextBox ActiveX Control when you Print Preview a report in Access 2000. However, FMS has a RichText control available that does not result in the behavior described in the article.
1999 VBXTRAS Thunderbolt Awards
Total VB SourceBook, is still receiving recognition and awards from the VB community! Total VB SourceBook has received the VBXTRAS Best Source Code Library and the Best Collection of General Purpose Components Awards. Each year readers of VBXTRAS -- a leading magazine for Visual Basic® programmers -- select the award-winning products because they’re the most intriguing, innovative, and promise the best value for Visual Basic developers. Awards
Total VB SourceBook Reviewed
Total VB SourceBook received another glowing review. This time from Visual Developer magazine.
"Total VB SourceBook calls itself “The Ultimate Code Library for Visual Basic”, and from what I can see it lives up to that claim....
"Anyone starting out with VB project needs Total VB SourceBook. While more experienced programmers will already know many of the techniques and procedures in this database, everyone will find something to use. The ability to add and index your own procedures in a multi-programmer environment makes this a tool no VB programmer should be without" - Matt Hart, Visual Developer Review
Total VB Statistics Reviewed
See what the experts are saying about our statistical analysis program for Visual Basic in the May issue of VBPJ or see full text of the article online.
"If you are looking for a small but powerful statistical calculation engine, Total VB Statistics can help. It is flexible and easy to use, and best of all, it writes the code for you." - Rama Ramachandran, VBPJ Review
Total VB SourceBook Wins the 1999 VBPJ Readers' Choice AwardTotal VB SourceBook, FMS' debut Visual Basic product, is already receiving recognition and awards from the VB community! Total VB SourceBook received the highly coveted Visual Basic Programmer's Journal (VBPJ) Reader's Choice Award. Each year readers of VBPJ -- the leading magazine for Visual Basic® programmers -- select the award-winning products because they’re the most intriguing, innovative, and promise the best value for Visual Basic developers. Take a look at the Ultimate Visual Basic Code Library and Code Repository...Click here! |
Total VB SourceBook |
Readers' ChoiceTotal Access Detective Reviewed
Total Access Detective was reviewed in the March 1999 Denver Access Area User Group Newsletter. Click here for full text of the article!
"Total Access Detective is valuable for those times when you have two or more versions or copies of the same database and you are not sure which one is the latest version. This program is a must have for those times when you have two or more people working on the same project, it takes the confusion out of trying to determine which changes or updates are the correct ones."
Total VB SourceBook Reviewed
Read the rave reviews Total VB Visual Basic SourceBook has received:
"A programmers dream!...all code in the SourceBook is completely reusable, with royalty-free distribution rights. And its perfectly commented too - just the right information for beginners and advanced developers alike...Smart, innovative and easy-to-use - this product is full of real-world solutions that you can't find anywhere else...and invaluable addition to anyone's development toolkit. A must-have!" -- WinPlanet Review
|
|
Total VB SourceBook Spring 1999 Buyers Guide, VBPJ, page 68. |
  4˝ out of five stars! |
Total VB SourceBook January 1999, WinPlanet Online Review. |
|
|
Borrow Code from the Library November 1998, VBPJ, page 15. |
|
Total VB SourceBook 5.0.1 for Microsoft Visual Basic August 14, 1998, Visual Programming++. |
FMS Wins 13 Access-VB-Office Advisor Reader's Choice Awards!
Seven of our add-ins won thirteen awards in the 1998 Access-Office-VB Advisor Readers Choice Awards. Access-Office-VB Advisor is the premier magazine for Microsoft Access. With this clean sweep of the majority of the Microsoft Access categories, FMS is clearly established as the leading 3rd party product provider for Access. The following is a list of our award winning products:
- Total Access Analyzer
- Best Access Add-In - Gold medal
Best Debugging Tool - Gold medal
Best Documentation Tool - Gold medal - Total Access Agent
- Best VB Add-In - Silver medal
- Total Access CodeTools
- Best Access Add-In - Silver medal
- Total Access Components
- Best ActiveX Control - Gold Medal
Best Interface Design Tool - Gold Medal
- Total Access Detective
- Best Debugging/Testing Tool - Silver Medal
- Total Access SourceBook
- Best Office Add-In - Gold Medal
Best Source Code Library - Gold Medal
Best Access Add-In - Silver Medal - Total Access Statistics
- Best Business Product - Gold Medal
- Team Access
- Best Version Control Tool
Rave Reviews!
Check our our online reviews, and see what the critics are saying about our products.
Connect with Us
Email Newsletter
Developer Team Blog
Facebook
Twitter
Support ForumFMS Resources
"Thanks! FMS products are extremely powerful, unbelievably stable, great timesavers, easy to learn, and an absolute pleasure to work with!"
Alison Balter, Author, Trainer, Consultant
Connect with Us
FMS Resources
"Thanks! FMS products are extremely powerful, unbelievably stable, great timesavers, easy to learn, and an absolute pleasure to work with!"
Alison Balter, Author, Trainer, Consultant
