Access Upgrades and Version Control

Version Control and Upgrading Access Problems

The next step for your database...

One of the beauties of Microsoft Access is it is very easy to write a database, with wizards and macros to help you on your way. As the database grows, however, there is a point at which a business is likely to benefit from professional support.

For instance, upgrading an Access database “should” be relatively straightforward. Unfortunately, this is often the point at which cracks will show.

If the database has not been built on strong foundations, or the developer has only basic programming experience, upgrading your software can create all sorts of problems. A lot of time can be wasted trying to resolve these issues. A scenario which we frequently see is that these problems have been “fixed” with unnecessary and inefficient workarounds.

Below are examples of business databases we have “rescued” or provided additional support for…..

Project Examples...

Excel Export with Access Version Control

Excel integration with Access was needed for the manipulation of large data sets. Our client also required improved version control to manage the distribution of his Genstat Market Size Databases to customers running different versions of Access.

Project example for Excel Export + Access Version Control

Access Database Problem When Upgrading

A property consultancy experienced problems with the Access database used to manage their business. This had been rendered unusable following a chain of events including an Access upgrade. We were able to locate and solve the problem quickly so they were soon back up and functioning again.

Project example for Problem following an Access upgrade

Custom Live Auction Management with Invoicing

We developed a Live Auction Management System customised to handle the specific requirements of Tayler and Fletcher, particularly with regard to farm machinery auctions as well as hay and straw sales.
The new system manages the complete process including compiling the catalogue, calculating commission and bidder premiums, generating bidder invoices, printing vendor statements, and balancing the sales ledger at the end of the auction.

Project example for Auction Management with invoicing

Solve Database Problems, Booking System and export to Sage

Having solved the underlying database problems for this client, we progressed the job management system, providing a custom booking system, improving the billing section of the database, and incorporating a customised export module to Sage Accounts

Project example for Solve Database Problem, Booking App, Sage Export