I just wanted to run this by everyone, I've got a access application consiting of two access database the front end with all the functionality that has tables that point at the back end which is just tables. Now I want to move the back end into sqlserver and just change where the front end looks for the tables.
I'm going to start putting this into a testing stage soon, can anyone think of any problems that might be caused by doing this. I'm slighly worried about auto numbers and thing like that. I kinda hoping that it will treat it in exactly the same way.