Is Access really capable?

[prabha_friend]

PowerApps could do the job if you're not working with big datasets
Sadly it gets exponentialy slower, and optimizing it is quite the nightmare
But if everybody has ms365 then you can work out a web based portal

Let's pull the mountain with our hair. If it comes then mountain otherwise just a Hair

 

[Pat Hartman]

I have three clients (100-200 employees) that each run their entire business except for an accounting package using Access applications.

If you don't have any development skills in any other environment, it will take you quite a while to learn the new environment and get up to speed. Even still, coding everything from scratch is a lot more work than using a RAD tool.

Divide and conquer. There is no reason to not create the back office application using Access which you claim to be fluent with. Then you can find a tool to use for the portal.

 

[prabha_friend]

I have three clients (100-200 employees) that each run their entire business except for an accounting package using Access applications.

If you don't have any development skills in any other environment, it will take you quite a while to learn the new environment and get up to speed. Even still, coding everything from scratch is a lot more work than using a RAD tool.

Divide and conquer. There is no reason to not create the back office application using Access which you claim to be fluent with. Then you can find a tool to use for the portal.

Even for a thirteen year experienced Ms Access Developer?

 

[prabha_friend]

Sorry. Not just Ms Access but Complete Ms Office Suite...

 

[Pat Hartman]

By other development platform, I wasn't referring to Excel. I was referring to a web tool.

 

[prabha_friend]

See you Soon... With the tool in Hand

 

[Pat Hartman]

Good luck