how to transfer a whole access data base to SQL SERVER

Hi Guys,

I have a Access database which have a forms, querys, txt files, how can i transfer all of the database as it is to SQL SEVER and dont have to make any changes.

please help and suggest
Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:
Hello ammartahir1978,

AW is absolutely right.

Adding to that, Access has an "upsizing wizard" that helps you in the process: the data are
moved to a SQL Server back-end, while the UI elements remain in Access.


Arthur_WoodConnect With a Mentor Commented:
What you are asking is NOT possible.  SQL Server does NOT have anything that corresponds to Access Forms, txtFiles, Reports etc.  SQL Server is a Database Management system, while Access is a Database Application development system.  You can transfer the DATA (Tables) to SQL Server, and continue to use Access as the User Front-End.  But there is no way to base your ENTIRE applications solely on SQL Server.

ammartahir1978Author Commented:
H Matthewspatrick, correct me if i am wrong so i can transfer all my data to sql and keep Access as front end, do i have to change any other stuff like links and stuff myself or access will do it automatically?

any detail or help can be apprecaited.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.