both Access and SQL server should be supported. oracle is too big for it.

Access

Advantages: Access is simple and convenient to deploy and very flexible to use. Mainly desktop database system.

Disadvantages: the data storage capacity is small, the security is not high enough, and it is easy to crack with user-level passwords. Under the C/S structure, there is a high requirement for the server, otherwise it will easily lead to MDB damage, with a concurrency of 255, but it is not adaptable to high-intensity operations. If the server is not good enough, the network is not good enough, and the programming method is not good enough, 6-7 people can visit at the same time, which will lead to MDB damage or death. The software system developed by VBA code cannot be directly compiled into Exe executable files, and it cannot be separated from Access or Access Runtime environment, which is relatively large (about 51M) compared with other software. Microsoft Access database has a certain limit. If the data reaches about 111M, it is easy to cause the server IIS to fake death, or consume the memory of the server and cause the server to crash.

sql server

Advantages: high security, real client/server architecture, graphical user interface, making system management and database management more intuitive and simple, and rich programming interface tools provide users with more choices for programming.

Disadvantages: Because of its powerful functions, manipulating data is more complicated than Access.