Results 1 to 6 of 6

Thread: MS Access Upsizing Wizard for Sql server Backend

  1. #1
    Join Date
    Aug 2009
    Posts
    50

    MS Access Upsizing Wizard for Sql server Backend

    Guys,

    I need your help. i use Ms Sql express 2008 for Ms access Frontend and backend in management studio i migrated all the tables and i am trying to link the table using OBDC upsizing wizard in that way but when when i do so is giving me the message as follow

    <<the Upsizing wizard only work with microsoft sql server (version 6.50SPS or higher>>

    would please help

  2. #2
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by FMKA View Post
    Guys,

    I need your help. i use Ms Sql express 2008 for Ms access Frontend and backend in management studio i migrated all the tables and i am trying to link the table using OBDC upsizing wizard in that way but when when i do so is giving me the message as follow

    <<the Upsizing wizard only work with microsoft sql server (version 6.50SPS or higher>>

    would please help
    Are you using the SSMA?

    See:

    Migration for Microsoft Access
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  3. #3
    Join Date
    Aug 2009
    Posts
    50
    Quote Originally Posted by HiTechCoach View Post
    Are you using the SSMA?

    See:

    Migration for Microsoft Access

    i was not using SSMA but i down load now and is asking license management i need to buy it ? please Help

  4. #4
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by FMKA View Post
    i was not using SSMA but i down load now and is asking license management i need to buy it ? please Help
    It is free.

    It has been a while since I last downloaded and installed it. I do remember there was a step to obtain a License key.
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  5. #5
    Join Date
    Aug 2009
    Posts
    50
    Quote Originally Posted by HiTechCoach View Post
    It is free.

    It has been a while since I last downloaded and installed it. I do remember there was a step to obtain a License key.

    I got it thank you i think using SSMA is more perfect

  6. #6
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by FMKA View Post
    I got it thank you i think using SSMA is more perfect
    Glad to hear you got it working.

    Good luck with your project.
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

Posting Permissions

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