Jan 12

Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by Access Version)

File server databases like Access/JET MDB and ACCDB files need to be periodically compacted and repaired for optimal performance and to minimize database corruption. This also eliminates database bloat that can occur as data is added and deleted in the database. Here's a Microsoft Knowledgebase article that discusses some of the issues.

Microsoft Access databases can be manually compacted from the Access menu. Unfortunately, over the last few versions of Access, the location of this command has moved around driving Access many users and developers crazy. Read this paper for how performing this critical system administration task across all versions of Access:

Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by Access Version)

 

Jan 12

Create a Backup and Disaster Recovery Plan for Microsoft Access Database Applications

Microsoft Access Backup Disaster Recovery Plan

If you create or take over a Microsoft Access application from someone else, you become responsible for the data in addition to the application and its queries, forms, reports, macros, and module code. Unanticipated disasters can occur, so it's important to prepare before they happen. The amount of effort and investment to spend for disaster recovery varies with the value of the application, but some basics apply to all applications.

A Disaster Recovery Plan is much more than making backups of your database. And if your backups are on the same machine and/or hard disk as your production database, that doesn't qualify. 

Read our paper on Creating a Backup and Disaster Recovery Plan for Microsoft Access Database Applications  for ways to limit your risk and headaches, while providing a professional solution for your end-users, boss, and clients.

Jul 23

Microsoft Access and Cloud Computing with SQL Azure Databases

Microsoft AccessSQL AzureWe at FMS are very excited about cloud computing and started developing solutions using Microsoft Azure including SQL Azure well before it was released to the general public. I feel cloud computing represents the next big platform change in the software industry and the most significant transformation since the introduction of the Internet in the mid-1990's. It will transform the internal hardware, application hosting, and data storage business the same way electric companies eliminated most organization's need to generate their own electricity.

Windows AzureWhile there's been lots of discussions of Azure with .NET and SQL Server, we also see lots of opportunities with Azure and the Microsoft Access/Excel/Office community. In fact, we're busily working on a way to integrate Access data and files with the cloud. Meanwhile, we'd like to share some tips and techniques for linking Access databases directly to tables in SQL Azure. This opens up huge new opportunities to create and deploy Access databases using a more robust, cheaper, and highly scalable platform that is enterprise quality.

 I look forward to your feedback on two new papers:

Jul 16

Guest Speaker on Radio Show: Start Up or Shut Up

On Monday July 19, I’ll be live on the local radio show Start up or Shut up! which covers creating and running a small business.  It’ll be from 2-3PM on 1580 AM in Northern Virginia.

Start up or Shut up! is a LIVE radio show Monday afternoon from 2-3pm on the Big Talker 1580 AM hosted by Mark Bucher & Tom Gregg. More info about the program here About Startup or Shutup

Jul 08

Celebrating the 4th of July, and Participating in our Democratic Processes

I spent the 4th of July watching the fireworks in DC next to the Lincoln Memorial. It's always a wonderful experience to do that beyond the basic joy of watching cool explosions. Sitting by the reflecting pool with friends and family let us reflect on what a wonderful nation and concepts our founding fathers created by prioritizing the freedom of the individual.

Over the past few months, I've had the fortune of participating in our democratic system much more than usual. 

I was recently appointed to the Fairfax County Information Technology Policy Advisory Committee (ITPAC) on behalf of the school board, which is giving me insight into the challenges our county and all local municipalities face with providing services to its citizens. Some of the problems are quite fascinating and complex. I've only been to one meeting and we won't meet until after the summer, so we'll see what comes of it.

Late last month, I was invited to participate in a lobbying effort on Capitol Hill as part of the Association for Competitive Technology. I did this twice almost 10 years ago, so it's been quite a while. ACT gives small technology businesses a voice amid the battle among the large players, and brought in participants from across the country for a one day blitz. It turns out that we as a group are very under-represented on the Hill and were warmly received at all the offices we visited. All elected officials want to support small business owners in their districts, but don't seem to meet them too often on the hill. I was very pleased to participate in small group meetings and had a chance to meet my Senator Mark Warner (D-VA, very impressive as he really understands the technology industry) and Congressman Moran (D-VA). We also met the legislative aides for Sen. Hatch (R-UT), Congressman Connolly (D-VA) and Wittman (R-VA), and Speaker Pelosi (D-CA). Unlike the others, the speaker's office is in the Capitol building and was an interesting maze to get to both physically and through security.

The general message was to make sure they considered the impact of their decisions on small businesses and how unintended consequences of their decisions may impact us. Whether it's regulating the internet, net neutrality, cloud computing, privacy, international laws, taxation, patents, etc., a lot of issues affect small technology businesses. Considering the impact of small business on employment in this country, it's critical that they don't create more problems than they solve.

I don't know how much of an impact we had, but it was gratifying to walk the halls of Congress and see how they operate. There are a lot of challenges facing our country and world. Technology holds the promise that it can help us increase our productivity and ability to address those needs in a meaningful way at a reasonable cost. I hope they continue to foster an environment that allows technology, innovation, and entrepreneurship to prosper for the common good.