DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  
Clint Covington: Software design, Microsoft Office Access : Cool As Ice uses Office Live and Access 2007 with custom ribbon

I saw this and thought you might like to see how one ISV has joined Office Live and an Access application.  Web access and rich client applications.  Nice!! 

Here is some information about the Access 2007 application that I’ve developed for Cool As Ice, which is a leading Norfolk-based supplier of air conditioning and refrigeration here in the UK. Cool As Ice wanted a bespoke customer contact system that they could use to hold data securely yet allow their workforce to use that data on their laptops, including adding and altering data, i.e. not just a read-only copy. Access 2007’s integration with Sharepoint meant it could provide the basis for a good solution.

The application holds its data in a workspace that is part of my company’s Office Live site. The choice of Office Live to provide the SharePoint part of the solution means that their data is secure and that Cool As Ice do not need to get involved in organising that part of the solution, concentrating instead on the things they do best. Backups of data are done by Office Live and of course, the Office Live Recycle Bin is there in case it is needed. If neither of these needs to be used, everything is handled in Access 2007, i.e. the normal end-user just sees Access 2007 and no web user interface.

The image below shows the main screen of the application, i.e. where the main customer contact information is entered.

Source: Clint Covington: Software design, Microsoft Office Access : Cool As Ice uses Office Live and Access 2007 with custom ribbon

 

ttfn

David

Technorati Tags: ,

Posted Wed, May 30 2007 12:29 AM by David Overton

Add a Comment

(required)
(optional)
(required)
Remember Me?

(c)David Overton 2006-23