I have an extensive database I would like to convert to SQL server. I created it in Access 97 and have upgraded to access 2000 (no further as all of the computers on the network do not support Access beyond 2000). I have a front end on each cmputer that uses it and a backend residing on one of the hospital servers.
I have tried converting the backend to SQL and the connecting the .mdb front end to it without success. Anyone that could give me or point me to step by step instructions would be appreciated. I have tried the suport.micrsoft site and have not found their info detailed enough.
I have tried converting the backend to SQL and the connecting the .mdb front end to it without success. Anyone that could give me or point me to step by step instructions would be appreciated. I have tried the suport.micrsoft site and have not found their info detailed enough.