• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 148
  • Last Modified:

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
  • 2
2 Solutions
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.

Patrick MatthewsCommented:
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.


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.


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now