Advice/Consultancy required on migration of Access db to web server -

[matt beamish]

Hi folks,
I run a membership database for a local society that holds a small private membership of 400 or so with around 80 institutional subscribers, and holds subscription information, payments made, subs owing, publications despatched, gift aid claims, general notes, orders and invoices etc. I have developed it as an Access db over the last 10 years, but I have just about had enough of doing this voluntary job and also at the same time want to make a membership database more accessible and also securely online so that someone else can take it on. I need someone to advise me on how best to achieve this, and also to do the necessary re-writing of the front and back ends.
Has anyone with direct experience of something similar any advice to give me?
thanks
Matt

 

[Minty]

You can migrate an access database back end to an azure cloud-based SQL Server.
It is relatively straight forward but can require tweaks to the forms and general design depending on how it has been put together.

This allows you to retain the existing front end, with some modifications.
Re-writing the whole thing for another Web-based front end would I suspect be a large task and not one to undertake lightly.

You may find someone to do this for you cheaply, but it can be quite time-consuming to do and set up properly depending on the complexity of the existing system.

 

[theDBguy]

Hi Matt. There's lot of options with different costs associated with them. Also, it depends on the size of the data and the number of users.