msaccess to sql

Results 1 to 2 of 2

Thread: msaccess to sql

  1. #1
    Mona Guest

    Default msaccess to sql

    can anyone tell me how to switch from msaccess to sql7. I already have a database set in access along with all the codes for insertion and updates in my asp files but it seems like msaccess is kind of troublesome. so I want to switch to sql7. How do i do it?<BR>thanks

  2. #2
    Steve Rowson Guest

    Default Use the Wizard!

    There is a wizard in Access 2000 that does the job for you. Most of your statements will work first time and if you keep an Access front end (this is a choice in the Wizard) you can still use Access&#039;s query designer to test your SQL statements as they are being used on the underlying SQL7 database. Avoid memo fields, they cause weird errors in VBScript code.

Posting Permissions

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