I have a database which I will like to create an sql backend for it.
I have installed sql server 2014 successfully.
I have also successfully installed Sql management studio 2012.
My issue is am unable to link the database for access to use the sql server as the backend.
I saw an sql migration software for access online which I tried. But when it gets to the point where it will have to connect to the sql server, it isn’t able to connect.
I can’t tell what went wrong.
Any help with this will greatly be appreciated