Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Move to SQL (2003)

    Does anyone have a good reference or any reliable information for moving a large Access 2002/2003 database into a SQL server? The database has a lot of queries and forms and such. When I tried the "Convert to SQL" command from within Access, the machine (or any machine) eventually hangs then the only thing brought over are the 80 some tables.. no queries or forms or reports, etc. Any help on this would be greatly appreciated! <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Move to SQL (2003)

    The only things you can convert to SQL Server are tables and queries. Forms and reports still have to be in a front end, Access, VB or something else. Macros and modules do not convert either.
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Move to SQL (2003)

    Charlotte has laid out the basics for you - SQL Server will only function as a back-end. There are several ways of taking Access tables and creating a SQL Server database - I presume the one you used was the SQL Server Upsizing Wizard that is available for Access. To better understand what the Upsizing Wizard does for you, take a look at <!mskb=294407>Microsoft Knowledge Base Article 294407<!/mskb> and you might want to look at a problem with large tables that is described in <!mskb=295231>Microsoft Knowledge Base Article 295231<!/mskb>. If by chance we misinterpreted your post, and you were trying to create an ADP, please repost with more info about where you are headed. Good luck.
    Wendell

  4. #4
    New Lounger
    Join Date
    Jan 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Move to SQL (2003)

    Thanks for all the info. I think I know where I'm going now. It's very appreciated! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •