I'm currently developing a small sized Windows application. For compatibility reasons, I'm limited to use MS Access as DB "backend" (migration to SQL Server planned but not doable yet).
In these days I have to take a decision. I have two options:
- Host MS Access files on NAS (Synology);
- Host MS Access files on a virtualized Windows Server (the hardware is a bit aged).
Which solution is better, in terms of reliable and fast database connection? I know it's difficult to give a 100% guaranteed answer with so little informations, so which tests should I perform to take my decision? Does someone of you have already faced a similar situation?
Thank you in advance.