The benefits of switching access BackEnd to sql express
I have an access DB, which is splited into a Backend and Frontend, that have c.a 100000 records in 60 tables.
I got this idea, that I can switch my Backend to a MSSQL Server Express. I would like to know Is it worth to do that or not? and which advantage do I have if my Backend is SQL Express and Front End access
Thank you for your ideas
The benefits of switching access BackEnd to sql express
===

I have an access DB, which is splited into a Backend and Frontend, that have c.a 100000 records in 60 tables.
I got this idea, that I can switch my Backend to a MSSQL Server Express. I would like to know Is it worth to do that or not? and which advantage do I have if my Backend is SQL Express and Front End access
Thank you for your ideas