Hi everyone I have an application that manages database . This application is used by 40 different computers over a shared network drive.
What I have tried:
I was using .mdb MS Access database and this file was on a network shared drive tp which my VB.net application connects. This was good but very slow till it got corrupted somehow. So I covered the database to sql server 2014 and I rewrote everything in my application to be compatible with sql server. Its very good but my organization will take about 3 months or more to host the database to a running server . And this is impacting my operations. So I need an alternative reliable solution to which I can convert my database and so that database can be used over network shared drive that accepts multiple users.