We have an Access database that is split into a front end and back end. Both are in Access. I want to migrate the back end into SQL. I was going to move the tables and leave the rest in the front end (I do know that it is better to have stored procedures in SQL but I am just not that sophisticated as a programmer yet).
What do I need to do to make this work? Do I have to purchase SQL and SQL management studio? Do I have to purchase a new server? They actually have an older server upstairs that I believe has server 2008 on it, can I use that?
Also after I move the backend data up onto SQL I would assume I have to reset all my queries because in SQL they get names like dbo.Customers instead of Customers.
Additionally, will this help with speed? The entire database seems to be slowing down because we have about 15 people on it. Each have their own front end.
I have never set up a server with SQL, in fact I have only just programmed in Access.
ANy advice is really appreciated!