With all that in mind, the old days playing with Access 97 and their Northwind example came back to mind. Although the Widget set from Access was fairly restrictive, it was sufficient to satisfy the simple requirement of this application. The single file-base database was fairly insecure, but it is something I am willing to give up for now in exchange for a rapid development model. One pleasant surprise was its ability to support concurrent user, and so far we have as much as 3 people access the database at the same time without too much problems.
After 3 weeks of hard work, the application went live on April 5th 2010. A good chunk of the time was spend migrating the data from an old Fox Pro database an Excel Spreadsheets into the database.
Access proved to be a good choice. We have been using the application for the last month or so, and adding more features and customization as we go. The latest module is a service report module which allow us to collect data correlating service calls by our support team back to the customer. In the beginning, it will seem like a chore. Hopefully over time, it will allow us to gain better insight in our business and better serve our customer.
I was very tempted to move the database to a SQL Server in the near future, and my justification is better security and better support for multi-user. The first issue regarding security is valid, but I am not sure it justifies the time and investment required at this stage. The second issue is simply my techie side talking, since the Access database should be able to support the current load without any problem.
Microsoft publish a great document to help user rationalize the decision of when to migrate from Access to SQL server. The document is simply named "When to migrate from Access to SQL Server" Inside the document, it has a fairly nice pie chart illustrating how many application will actually need upsizing:
Source: When to Migrate from Access to SQL Server - Microsoft
SQL Server Salesmen are probably not too help with the Microsoft employee who wrote the document :)