Post reply

Access to SQL

  • July 13, 2010 at 5:16 pm

    #141036

    We currently have an access database with a front and a back end. The front end is via VB.

    We are looking to convert it to sql server and wanted an outline of how we should go about the entire process.

  • July 13, 2010 at 6:09 pm

    #1192441

    Use http://technet.microsoft.com/en-us/default.aspx

    In the input box type: "upsizing access to sql server" it will return some 650 links to articles, scripts, blog postings that discuss this question. If you can not obtain the required assistance from those, return and post your specific problem(s).

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 14, 2010 at 6:02 am

    #1192717

    In addition to what Ron notes, spend the time to learn T-SQL. Access querying and T-SQL querying are just not the same.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply