Questions in blue.
We have eventually learned to connect our front end using SQL server as back end. Questions. I assume from what people informed some time ago that there will be no limit on open connections?
MWeb hosts our website, and I accept that our Access database without SQL server can not be hosted for customers to be used for processing data. Can MWeb or any host, host our database for processing by customers through the internet, when the back end is SQL Server?
I assume that the well known international Accounting packages uses different strategies.
a. Some of them may work like my bank where all data is stored on the hosts space and no front end on the users computer. The user logs in and process.
b. I have experience where I downloaded the whole application to my Computer and store all my data on my computer. When there are upgrades it get emailed to me, we activate.
c. Ruben spoke about the option of a front end on every users computer, with one back end stored by our host.
If I could choose I would want option A. Is that possible or what is needed to use that option.
More than 25 years ago, before Windows, I had some experience using Novelle networks with DBaseIV database. I might be wrong, remembering that our database was on the server only. On a local network on a client Computer we simply set up a manual menu software to connect to the main EXE file in the DBaseIV application, and then we can work on the database from the client computer, nothing like a front end being loaded on the client. Question. If the back end of our database on a local network of 20 Computers is on the server, is it compulsory that on every client the front end must be installed, or is there a way like we had as described above? The concern is here if an upgrade is needed on the front end, is the only way to upgrade one by one?