I use a database application ysing ms access(Both front end and Back end) i want to change only the back end t

Question

I use a database application ysing ms access(Both front end and Back end) i want to change only the back end to sql server with out change the front end.tell me how

Answer 1

OK

Adding to what Tofu has said depending on the version of MS Access you have there is a migration wizard that can port the date to SQL Server.
However you do need to think about what you are doing.
The optimal design for an access database does not have the same criteria as a networked sql server application.
If you have used many queeries and nested queeries these will perform very pooly in a SQL server environment.

Good Luck !

Answer 2

Depend on which SQL server you moving to, MS-SQL has the ability/tool to upgrade from a MDB, but you still would need to modify your front end as the data structure/location are now different,.

Answer 3

nope, the ms access db management engine will keep track of what db the form fields pointed to. But yes, if you want user has the new front end form look