View Single Post
Old 10-06-2016, 04:11 AM   #1
Newly Registered User
Join Date: Oct 2016
Posts: 14
Thanks: 25
Thanked 0 Times in 0 Posts
letsaccess is on a distinguished road
Post Need some advice

Hi ,
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

letsaccess is offline   Reply With Quote