Is it possible to somehow synchronize the work of the site with Microsoft Access?

Question

Microsoft Access

Interested in such a moment, is it possible to somehow synchronize the operation of the site with Microsoft Access. Roughly speaking, the plot is as follows: there are many objects, let's say houses, people move in / move out, pay / don't pay, something breaks down and needs to be fixed, and so on and so forth; there are managers who monitor all this and enter information into the Microsoft Access database, and then, say once a week, this information is uploaded somewhere so that it is updated in the personal accounts of the administration on the site and the company's customers.

Is it feasible? How much such internal CRM can cost? Interested in a rough price threshold "from".

Answer 1

Access - at a minimum, costs money for each installation.
It's easier to write a normal website either in php or ms iis + asp.net mvc
And then all managers, residents and others go to this "crm" - some leave a request about "the light bulb in the entrance is dead", the latter monitor this and call the appropriate services, third monitor payment, fourth administer and monitor

Answer 2

And why is MS Access here? He's single user.
You make a normal web interface and let the managers immediately enter everything into the central database. Any SQL server can be used as a central server. At the same time, information will be available not once a week, but immediately.

Answer 3

Yes, it is not difficult to implement:
Option 1: Directly connect from Access to the site database and pour it into it. Dirty, bad way (if something messes up somewhere or the site base changes, it can be sad). But the method is cheap and fast.
Option 2: If the site has an API and you have a familiar VBA developer, everything will work as correctly as possible. In VBA, you can work with both XML and JSON sites (no matter how strange it may sound
) - and you can synchronize at least every day "on the fly"

Answer 4

It is possible to implement. In one of my projects, data is loaded from an Access file using mdbtools.
A brief description is here: devzone.zend.com/1315/reading-access-databases-wit...

Answer 5

Interested in such a moment, is it possible to somehow synchronize the operation of the site with Microsoft Access. Roughly speaking, the plot is as follows: there are many objects, let's say houses, people move in / move out, pay / don't pay, something breaks down and needs to be fixed, and so on and so forth; there are managers who monitor all this and enter information into the Microsoft Access database, and then, say once a week, this information is uploaded somewhere so that it is updated in the personal accounts of the administration on the site and the company's customers.
Is it feasible? How much such internal CRM can cost? Interested in a rough price threshold "from".
Well, yes, this scheme is feasible - from 3000 rubles