how to transfer a whole access data base to SQL SERVER

Posted on 2007-10-18
Last Modified: 2010-03-20
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
Question by:ammartahir1978
    LVL 44

    Assisted Solution

    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.

    LVL 92

    Accepted Solution

    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.



    Author Comment

    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.

    LVL 92

    Expert Comment

    by:Patrick Matthews

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now