Forum Discussion

Brian_Hayes's avatar
Brian_Hayes
Brass Contributor
Feb 25, 2020

Moving Away from MS Access

The organization I work for is wanting to move away from Microsoft Access databases where possible, and we have started exploring what tools our current Access databases could be moved to.  Is there ...
admin
developer
office 365
ITLouis69's avatar
ITLouis69
Copper Contributor
Mar 27, 2024
I have built more Access databases in the last 20 years than I would like to admit. For some projects Access can be a quick and easy solution. When the Access database becomes difficult to manage - size is too big and too many users needing to access it at the same time - I have been converting them to Oracle APEX web applications which look and feel like an Access database in many ways - tables, queries, forms, reports, data exports, data imports, low code, etc. but with the benefit of accessing the database from any device connected to the internet. I found that pricing is pretty competitive as well. A 250 megabyte Oracle APEX database in the cloud using shared hosting runs about $50.00 a month and can be used by around 15 people. From there it can be easily scaled up.
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Mar 27, 2024

    ITLouis69 et al.

     

    I just re-read most of this discussion. It was suggested to me that this might be a good topic for my Access User Group.  

    I run one of the Chapters of the Access User Group organization. I'm always on the lookup out for interesting topics that may not be on the beaten path. Would any of you be interested in joining us for a discussion of your concerns and possible alternatives?

     

    I'm scheduling now for later in the summer this year. 

     

    At this point, it's kind of an idea, not a plan, but if there is interest, we can make it happen.

     

     

    • Rudyp16's avatar
      Rudyp16
      Copper Contributor
      Nov 27, 2024

      Hey George,

      if i create an app in Access and end my subscription, can i still run the apps or are the apps useless if i do not re-subscribe?

      I’m 82 years old, retired from it and have created many access apps for the company I worked for. Subscriptions were not available then, so that’s why I’m asking.

       

      thanks,

      rudy

       

      • AL2001's avatar
        AL2001
        Copper Contributor
        Nov 28, 2024

        82yo?

        To be fair most Wintel platforms are 64 bits now. So this would be a tough ask.

        What does your app do? Ie. the most simple one?

      • George_Hepworth's avatar
        George_Hepworth
        Silver Contributor
        Mar 27, 2024
        Please contact me via private message here.
    • Fatire's avatar
      Fatire
      Copper Contributor
      Mar 27, 2024

      George_Hepworth I’d be up for that 🙂 I eventually decided to move to Azure and am just starting to convert everything over. 

      • George_Hepworth's avatar
        George_Hepworth
        Silver Contributor
        Mar 27, 2024
        Contact me, if you will, via private message.

Resources