What is bad base on MS Access?

Question

Microsoft Access

Good day.

I won't go into too much depth, it's a simple question.

There is a large, large base on MS Access, you can say the whole enterprise works in it. SQl is not used, users sit on a server in it via RDP.

It is necessary to collect at least 10 reasoned reasons for leaving MS Access

Answer 1

Access is
1. Outdated solution. It is becoming increasingly difficult to find a specialist who could solve problems if something happens, and the longer the transition is postponed, the more painful it can be later.
2. Access is not multi-threaded. multiple users can interfere with each other.
3. Access is not very reliable in terms of fault tolerance - one (at best, several connected files), but this is work at the file system level. Lack of online backups, inconvenient structure for creating them. With a large database, problems are possible. It is almost impossible to make incremental backups.
4. Access paid. It can work normally only on the paid Windows platform.
5. The implementation of many things in Access rarely makes it easy to switch to a new version of the same Access, which can interfere with its performance even within the current platform.
6. There are no convenient regular ways to create online forms. Through IIS, this is again a paid solution with a bunch of crap.
7. RDP itself is not the best solution just to enter data into the database. Even with a small increase in users, the load on the server increases very much even when idle. While a web sql solution, it may even be invisible to users, the number of which has increased by an order of magnitude.
What access is good for:
1. First of all, it is a combine. Everything is his own, everything is in place - forms, tables, program code, standards. Nothing else is needed.
2. The application has already been written, it works, it is familiar.
You need to switch if there are funds for this (for the migration itself) and if there are some fears that access will not suit you in the future. If the expansion of the company is not planned at all, then it is necessary to explain the business benefit.
If you use licensed software, then from this point of view it is quite possible to find a benefit by abandoning rdp, windows server and office with access, replacing it all with a free linux server + apache / nging and implementing logic in php / python / java / perl ( whatever your heart desires) and a free database (mysql, oracle 1

Answer 2

1 reason, but a big one - in case of an incorrect exit from Access, the file must be "restored", at this time all the rest go on a smoke break. MSSQL - there is no such thing.
as a first step, just replace data storage from Access to MS SQL. Most likely even Express will suffice.

Answer 3

1. the base is local

Answer 4

Or maybe she is not bad for the tasks that she performs? How can a person from the outside know about this if there are no details?

Answer 5

I think she's just amazing

Answer 6

Hello!
Reading the answers to your interesting question, I was disappointed to see that the answers are mainly those who are not particularly versed in the topic.
As for such a wonderful product as MS Access, I can say that as a database management tool, Access is designed for a local Database like "Me and my CD shelf". Whether it means that it is necessary to refuse use of MS Access?
The answer is a resounding no .
The fact is that the Access "experts" who unsubscribed above did not take into account the fact that Access can be used as a client to an industrial scale Database (for example, Microsoft SQL Server). Those. the database itself will not be Access, but you will connect to this database using MS Access. Access has rich database interface features, forms, various controls, and reports.