Total Access Admin offers real-time monitoring of users entering and exiting any Microsoft Access database across your network. An update of Total Access Admin 2007 was recently released. All registered customers were notified of the update via email with download instructions. A free trial version is available if you are not familiar with Total Access Admin.
Follow FMS on Twitter
Follow fmsinc on Twitter! We are frequently tweeting about topics that should interest subscribers of our blog, so tune in. There are a lot of great Twitter clients, including Tweet Deck, that you can use if you don't already have one installed.
FMS Offers Custom Microsoft SQL Server Database Consulting Services
As you may know, our Professional Solutions Group offers custom Microsoft ASP.NET solutions, but we are also known for providing Microsoft SQL Server consulting services for a variety of clients in the private and public sectors.
We encourage you to read more about our SQL Server database development services. Please contact us for a free assessment of your organization’s requirements.
FMS Offers Custom Microsoft ASP.NET Website Development Services
Over the past year our Professional Solutions Group has delivered some notable ASP.NET web projects, including The HotMommas Project, a case study competition website for women entrepreneurs that has received a lot of press, and a competency and courseware management system for the DoD’s Defense Acquisition University.
We encourage you to read more about our ASP.NET web development services. If you need a quality website, we have an experienced group of business consultants, web developers and database experts that would love to help. Please contact us for a free assessment of your organization’s requirements.
Video: Migrating Your Data Tier to SQL Server: Strategies for Survival
I participated on this panel at the Microsoft TechEd Conference to explore the different reasons and approaches for migrating applications to Microsoft SQL Server. In addition to moving the data to SQL Server, ideas are presented for transforming applications to offer additional features while maintaining budgets. (43 minutes)
Video on the History of FMS: Surviving Uncertain Times
At the Microsoft TechEd conference. Microsoft’s Mary Chipman conducted a one-on-one interview about the history of FMS and how we’ve survived the economic and technical cycles over our 23 years of existence. Learn more about FMS, our successes and challenges over the years and today. (28 minutes)
Video: The World Turned Upside Down: Development Strategies for Lean Times
Worried about your job or career? Uncertain about what to do to protect your future?
Watch this video from my panel discussion at the Microsoft TechEd Conference. Hear me share my experiences at FMS with fiver other developers, and different ways we’ve survived over our careers. Entitled The World Turned Upside Down: Development Strategies for Lean Times, the video is 51 minutes.
Video: Let’s Talk about Software Consulting as a Business
Here's the video from my panel discussion at the Microsoft TechEd Conference. Taped on May 11th at the Los Angeles Convention Center, hear me share my experiences at FMS with two fellow software consulting firm entrepreneurs. Learn from our efforts over the past two decades, the challenges we face, and how we've been successful. Entitled Let's Talk about Software Consulting as a Business, the video is 54 minutes.
Create a Continuously Emailing System with Total Access Emailer
Discover how Total Access Emailer can support a table driven system to continuously send emails from your Microsoft Access application. With an instance of Microsoft Access running Total Access Emailer’s programmatic interface, you can automatically send emails from a table. Create a custom email in your application and simply add it as new record to a table. The email is automatically sent without interrupting your application. Read the article for more information on how easy this is to implement.
Microsoft Access Queries: “Unique Values” (DISTINCT) vs. “Unique Records” (DISTINCTROW)
When creating queries in Access, you may have noticed the query properties “Unique Values” and “Unique Records”. Are you familiar with the difference between these properties?
“Unique Values” and “Unique Records” correspond with the DISTINCT and DISTINCTROW statements (respectively) in the query’s SQL. Although they sometimes provide the same results, there are significant differences in how they work:
- DISTINCT checks for unique values only in the fields selected for output, and eliminates duplicate rows. Results are not updatable, since they do not necessarily correspond with a unique record.
- DISTINCTROW checks for unique values in all fields in the table that you are querying, not just the fields listed for output. If the table is keyed, the results are updatable, since they correspond with a single record in the underlying data.
Learn more and view an example of the differences in our new paper on Microsoft Access Queries: Distinct versus DistinctRow.
Visit our Microsoft Access Query Help Center for more query tips.