Currently have a MS Access front -end that had it database in MS Access as well. The database was then "ported" over to SQL Server (Express) and the code-base adapted to run against SQL Server. It is time to retire the MS Access app and just have a light client ( or web interface) to run against the SQL Server backend. THE MS Access app. has many forms and runs it's own queries (which must now be put into the new front-end or preferrable, thrown back to the database for processing (although these are just logic based processes that use the returned dataset from SQL Server.
The final solution will be hosted on Windows Server with SQL Server Express as the underlying database. The modern front end (JavaScript / NodeJS, or whatever you recommend) will need to perform the same functionality as the existing MS Access application.
... Show more