what are the disadvantage of ms access
Answers
Answered by
1
Finite – Microsoft Access is useful for individual departments or small-to-medium business sectors. Any sector whose usage goes beyond 2 GB will hit a wall and discover limitations.
Structure Query Language (SQL) — SQL for MS Access is not as robust as MS SQL Server or Oracle, to just name a few.
One file — All the information from your database is saved into one file. This limits options and how you choose utilize data; slowing down reports, queries, and forms. Its performance becomes slow as the user scales data size. Multimedia data can use up MS Access limited space quickly.
Static-Friendly — It’s difficult to publish files a part from static files.
Similar questions