Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002

    Unanswered: Sequel Server with MS Access front end

    In the new year, I intend to convert an Access database to SQL server 2000.

    Any general advice would be welcome. I see there is a wizzard but not for sequel server 2000.

    I am particularly interested in sending parameters from Access to Seuel Server and receiving back ony the results.

    Many thanks


  2. #2
    Join Date
    Feb 2002
    Which version of access are you using ?

  3. #3
    Join Date
    Jun 2002
    You can use sql pass through queries. But using MS access wizards is a bit of a no no try using ADO to access the database directly and youll have full control over how the data is transfered and manipulated

  4. #4
    Join Date
    Dec 2002

    Re: Sequel Server with MS Access front end

    Hi Jim,

    I am working on the same thing and have found DTS to be very effective. To transfer the table structures and data in SQL, first create a new database. Then, use DTS to transfer the table structure and data simultaneously. Go into your enterprise manager and expand your new db. Expand tables and click on tools - DTS should be your first option. The wizzard will walk you through the rest.

    Another option is to use an upsizing wizzard through Access. You will need to download this option from MS's website.

    Good Luck!

Posting Permissions

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