What Next ?

[ECEK]

I have my SQL back end and my all singing, all dancing Access Front End.

What would I use to replicate my front ends over my company network, with a nod to a Cloud environment in the future?

 

[Minty]

Have a google or search on here for Automatic Front end Updater.

Essentially you have a storage location that holds a master copy of your front end.
You have a version number embedded in or associated with the local copy of the front end.
You have something that compares that version to a master version, and if required copies it to the local location.

The master file location should be read only so that no-one (except you) can open it or overwrite it.

 

[ECEK]

Hi Minty
I want to study an alternative to Access, sorry that that wasn't clear.

 

[Minty]

Ah - I'm afraid you're right, not obvious.

If your looking at building alternative new front ends, particularly cloud based, then you're looking at far more involved programming/tools.
Access is a RAD tool, (Rapid Application Development), and to be honest their isn't much out there that is anything like as simple to use.

Even creating a basic form will require some serious programming with something like .Net , C# or any of the myriad of other methods.

They have application layers, and most use a framework to ease the pain.
Time for some serious reading / learning.