Forum Discussion
Split Database,
Two thoughts leap to mind.
If there is a compelling reason to invest time, effort and other resources in creating a new interface, that could be a useful expenditure of the client's budget, of course. Or, if you are creating a new application on speculation that it can be marketed, expenditure of your own budget.
However, those costs should be compared to the cost of migrating the tables from an accdb (or mdb) to Azure SQL tables and reworking the Access accdb interface--to the extent needed--to work efficiently with the Azure tables. That's not automatic, but it can be substantially less work than a full-on replacement interface.
In other words, if the client you have in mind can't support a local Access front end, or won't for whatever reason, incurring conversion costs can't be avoided.
Leaping to that position because "everything is in the cloud" today is not such a compelling argument.
Proceed wisely.
Azure hosting costs for a single Azure SQL database can be from ~$5.00/month US to several hundred dollars a month, depending on configuration and usage.
Colin's Access User Group enjoyed a presentation last night on adding a browser based interface-- not replacing the Access interface. I'm sure it will be available on YouTube soon.
https://accessusergroups.org/europe/event/access-europe-2023-08-02/
Hi George, George_Hepworth It's only fair to inform you of who I am. I am a Commissioning Manager for Oil & Gas plus Power Facilities. I saw a need back in the mid 90's for a "Commissioning Database". So, I self-taught myself how to write in MS Access and bought the Developers Edition. I knew what we needed to capture to handover to the client. I used the 1st edition in 2003 ona O&G Offshore Production Platform, then again in 2005-2011 on another O&G Production Platform. By now several commercial Database software programs are out there so I just let my database lye. They cost the client much more to use than mine, but the big corporations don't seem to mine the cost. Project Managers do not like to stick their neck out for a little-known small guy. The go with the big guys with a million-dollar marketing budget.
So now I wish to get it out there on a low budget and do monthly leases from project start to completion for a minimal fee. The programmer I hired back in 2005 to assist me because of my duties as Commissioning Manager, is going to again assist me, so, I offered him a full 50/50 partnership. Hopefully it will work out. Thank you for your input.