Results 1 to 2 of 2
  1. #1
    TOPSie is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    108

    Starting from scratch in 2022

    I have been given a simple csv file and require to put a front end on it to change and add records. As I know a bit about Access I knocked up the required functionality in half a day. Single table, one screen to do a simple text search and one screen to display / update a record. So almost a trivial application. It will need a little refinement to implement some input rules but basically that's it.


    However the application will be used by up to 100 people (but usage will be very low) and all the users are developers who are into things like Azure and "Cloud" and all the modern tools etc.
    MS Access is all a bit old hat - so does anyone know of the best tooling to implement this very simple application in a "modern" environment?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,412
    Not clear if you are editing the csv file or uploading it once to access and editing there from then on, or having uploaded and edited then saving back to the csv file

    Another old hat solution - Excel - but will only allow one user at a time. You can create forms and add code to maintain data integrity

    Azure is just a database, so upload your csv file to there and have your front end link to that instead of an access ACE backend

    If users do not have access installed, provide runtime

    other FE development environments - Powerapps, Visual Studio, assorted online data entry solutions, they all have limited functionality compared to Access, but you don't need much so shouldn't be a problem

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 07-14-2022, 06:52 AM
  2. Replies: 21
    Last Post: 08-14-2021, 12:21 PM
  3. Use table a bit like a scratch pad
    By GraeagleBill in forum Programming
    Replies: 3
    Last Post: 01-18-2018, 12:58 AM
  4. Questionnaire DB from Scratch
    By jomby in forum Database Design
    Replies: 4
    Last Post: 05-18-2012, 01:20 AM
  5. Help w/ DB from scratch.
    By ellixer in forum Database Design
    Replies: 9
    Last Post: 11-30-2010, 10:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums