- Joined
- Apr 19, 2020
- Messages
- 632
- Likes received
- 144
- Thanks received
- 9
How much more time does one need to identify that one is running one's business on legacy technology? Your solution, such as it is, does not resolve the problems that have already been identified. Whilst I understand your expedient position, it is not one upon which I would run a business.
MS Access is old sure, but likely just as SQL Server. I checked at Microsoft website and the lastest is Access 2019. That doesn't sound legacy at all.
Problem seems to be that the database is "too big". If you move it to another system it is still going to be perceived as big.
The problem seems to be the fact that the hardware it is running on makes it being perceived as big. 6GB is nothing in 2020.
Update your hardware and then reassess whether it is still an issue.

