Moving Ahead Online Ltd. -  I am a Freelance Microsoft Access Database and WEB Systems Developer/Programmer specialising in Database Development, Access, SQL, Foxpro. Design, Programming and Development of both local network and Internet based applications. +44 (0)20 8123 0528  

E-mail: admin@dennismcdermott.co.uk  
Home - About Me - Clients and Projects - Training - Software/Programming/Technologies - Hosting - Websites - Testimonials - Contact
 

Clients and Projects

These are a few of the companies I have worked with recently.
 
  Clients and Projects
121 Fundraising Ltd.
301 Design
Abbey Storage
ABS Wastewater Technology Ltd
Acacia Conservatories
Advice North Lincolnshire
Air Heating (Southern) Ltd.
Allianz Global Corporate & Specialty
Almond Art
Alpha Impact Ltd.
Anitox
Art du Midi
Barconn Limited
Barnet and Chase Farm Hospitals
Blairgowrie Guest House
Brentwood Communications
Broadway Records
Bruce Burlington & Co. Ltd.
Cachet (London) Ltd.
Camping La Corconne
Canon Consumer Imaging
Careys Private Hire
Dartford Council
Disabled Living Foundation
Dellcourt House
ESAB
Excel IT Ltd.
Fleetwood Building and Maintenance
GAP Photos
Gites in the Languedoc
Haymarket Publishing
Hiltongrove Audio Bank
Hiltongrove Business Space
Lansbury International
Le Palais des Roses
Lynwood Lodge
Marie-Louise von Motesiczky
Metacosm
Metal Cleaning UK Ltd
Midaye Somali Development Network
Moving Ahead Online Ltd.
MSL Medical
Pepperneck
Pro-Talk
Regent Carriage Services
Rail Professional
Rail Professional Development
Sea Containers
South Essex Gymnastics Club
South & East Essex Training Group
Standish Metal Treatment Ltd
Sunnyseek
The Gifted Goat
The Lamp Company
Thompson and Morgan
Total Crane Services
Virtual BM
Wasteking
Weatherbys
Moving Ahead Online Ltd (MHOL)

MHOL contacted me to discuss the potential for creating a system that would synchronise data held on their local servers with their award winning website.

After an initial meeting and discussion relating to other data synchronisation systems I had written I was engaged by MHOL to undertake the development of a system.

Website Synchronisation System

MHOL were manually updating their website with conveyancing details and as their business was growing this was becoming impractical. The company decided to install a proprietary case management system. My task was to synchronise the data within the in-house case management system with the website.

I created specification documents that covered the interaction between the in-house case management system and the synchronisation system, as well as between the synchronisation system and the existing website. I created the system using Microsoft Access, and also utilised IIS to provide a platform for the ASP pages that are involved in the synchronisation process.

The system compares data in multiple data tables, and adds, updates or deletes data on the website as appropriate, the system also integrates with pre-existing code on the website that sends HTML based e-mails to both clients and agents detailing the progress of the conveyancing process. The system was written so as to be autonomous in that it did not require any changes to the existing website source files.

System Features

  • Easy configuration.

  • Data availability checking.

  • Configurable synchronisation period.

  • Configurable data and website location information.

  • Provides feedback to user of both local synchronisation analyses and online synchronisation progress.

  • Stores self maintaining process history.

See examples of some of my Microsoft Access Development and VBA Programming Projects here...
 
© Dennis McDermott 2001-2017  -:-  Dennis McDermott is a Freelance Access Developer at Bespoke Software Development Limited