The FMS Buzz Email Newsletter

The Buzz is a monthly Free email newsletter highlighting the latest news, technical papers, time saving tips and techniques, products, and other resources for Microsoft Access, SQL Server, Visual Studio .NET, and Visual Basic 6.0 users and developers. Our topics are commonly referenced by other experts, newsgroups, blogs, and newsletters in the community. Sign up now so you get it first!

Recent Issues

• December 2011
  Happy Holidays! Total Access Components 2010 Ships, Popular Blog Topics, Windows 7 SP1 ADO compatibility, Sentinel Visualizer
• November 2011
  Free Preview of Total Access Detective 2010, Updates for Total Access Emailer and Total Visual CodeTools, MS Access 2010 Error Reference List
• September 2011
  Total Access Startup for Microsoft Access 2010 Shipts, Using Terminal Services and RemoteApp, Treating Exchange and Outlook as a Database
• August 2011
  Total Visual CodeTools 2010 Ships, New Microsoft Access Developer Help Center, Innovations Video, Total Access Analyzer Product Review
• June 2011
  Free Total Visual CodeTools 2010 Preview, New Microsoft Access Query Center, Creating a Backup and Disaster Recovery Plan, Custom Software Solutions for Large Businesses
• May 2011
  Meet Luke Chung at the Portland Microsoft Access Conference, Total Visual SourceBook Review, Facebook Twitter Share Our Webpages, Supporting Human Rights, New Microsoft Access to SQL Server Migration Assistant (SSMA) Released
• April 2011
  Total Access Emailer 2010 Ships, Join our Facebook Page, Terminal Server and RemoteApp, Windows 7 SP1 Complications, Sentinel Visualizer for Law Enforcement and Investigations

Sign Up or Update Your Contact Information

Some Subscriber Comments

I used your advice about looping through Recordsets on a project at work. I simplified the project and exceeded expectations; many thanks!
--Greg Dermer

Glad to get your newsletter today. I'd been trying to figure out a way for Access to mate with Outlook, then Poof!!!, the answer was in your email, Access tip...five easy steps to retrieve info from an Outlook data file into an Access database.
--Paul Binet, Germany

Luke,

Thank you! Thank you! I have just finished reading your paper, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Microsoft Access and its capabilities.

Recently I had the opportunity to prove to my employer that a proper redesign of an existing Access solution was the better choice to make. The previous design was completed by what Access professional developers would consider a rookie. Over 30 users were sharing the same MDB program which also included the tables. Egad!

The business was screaming for help and the IT staff, not knowing any better, claimed that if they pushed the data to SQL Server, the problems would go away. Wrong!

I rewrote the application using unbound forms and split it into an MDE and MDB, altering the Shift-Key-Bypass property in both to prevent unwarranted access. The business loves it! The amount of data created annually didn't justify moving it to SQL and I knew their connectivity issues would be corrected once they used my application.

I have been writing applications in Access for over 7 years, learning and growing each year.

I had the opportunity to attend the Advisor Developer's Conference in Phoenix. After attending a session that spoke highly of Total Access Analyzer and the other FMS Access tools, I knew I had to purchase them. Thanks to your company's products I have reduced my development time and technical documentation time greatly.

Once again, thanks for your document and I look forward to reading more.
--D. Dowler, Information Systems, Enterprise Rent-a-Car

I just wanted to thank you for providing a link to the FreeWheel utility that enables scrolling within the Visual Basic window. What a joy it is to be able to move up and down the screen freely. My partner thinks I'm completely barking that such an insignificant thing could provide such pleasure but I'm sure you guys know how frustrating it is to keep moving the scrollbar manually.I always read your tips section in the newsletter as I'm self-taught and work from home mostly so I don't get the benefit of working with other more experienced colleagues and pinching all their good ideas! Thanks again.
--Linda Lawson, United Kingdom

Hey, I love you guys. I didn't know about the Access decompile tip. During development, my application database had ballooned to over 21 megabytes. I ran the Microsoft Access decompile tip, compile and save modules, and compacted, and it was reduced to just over 12 megs; what a huge reduction!! I'm amazed. Thanks for this great tip. It was just what I needed.
-- M. Baldwin

"In this field, I need every resource possible to keep me more up-to-date than my clients; the FMS Buzz provides me with just that type of valuable information with each and every issue."
-- James Overholser 

The Buzz is a monthly Free email newsletter. If there is any topic you would like our experts to cover in future articles just let us know. You don't want to miss another priceless issue.

Sign Up or Change Address Now!