Good afternoon everyone.
I would like to underline that i never used SQL, i hear something about it and i was always interested to use as back-end database but for some reason i never went deep to understand what and how to do.
My problem: i have an MS ACCESS application where the database is split in BE and FE. BE Database is actually located in a company server folder and you can understand how much is slow especially if working from home.
I hear that using SQL as BE source and link the table in FE trough SQL should increase a lot the performance. The problem is that i don't have idea on:
1. What i need;
2. What to install;
3. How to move my ms access BE tables to eventually SQL;
4. If one day i will be able to cover the 3 previous points, how to link the SQL table to the FE database for the final user.
Just some information: i'm working in a company where any required installation (if not present) need authorization.
Hope in this fantastic group to get some tips how to do because the way we are working now it is ok but performance in term of speed very very low.
Thank you for usual and kindly support.
L.