I am new with MS Access and I start working with new company which they have a big Access DB file about 1 GB with many tables and relations ,I want to know what is the best solution for this situation to improve the performance and security and keep it easy also,
1- Export all data to MS SQL or MYSQL then link them to MS access as front end
2- Make more than MS access back end and connect them to 1 Access front End
3- Anything Else .
I think the first option is good but I don't have many experience with SQL and I hear some errors appears when do something like that because of ODBC .
I am really confused which choice I must go through it because I must stuck with it