Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Convert to SQL (2002 Access to SQL)

    Hi there everyone!! im looking for some help on a certain matter, on the promise of a payrise from my boss.. so i thought this place would be better than any to start.
    Basically we link back ends to the front end using code. Some of our customers have more than one back end because they have more than one company to account for. They have a login interface where they can select which backend to link from a code populated list box. in our backends we have about 300 tables, some vary in the amount of data that they hold collectively as some are more often used than others. i would like to know how i can convert these tables and their data to sql server tables and how i can then make a login where they can select which sql database to link to, then link to it using ADO <img src=/S/cauldron.gif border=0 alt=cauldron width=20 height=20>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert to SQL (2002 Access to SQL)

    Daryl,

    Is this related to <post#=511,518>post 511,518</post: >?

  3. #3
    New Lounger
    Join Date
    Sep 2005
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert to SQL (2002 Access to SQL)

    No....that is my own contract! This is something that my boss has asked me to do as we are planning to develop in VB.net so we want to get this sorted in access first. So your help on how to do it would be appreciated

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert to SQL (2002 Access to SQL)

    Access has a wizard for converting tables to SQL Server: look at Tools | Database Utilities | Upsizing Wizard. This will also create linked tables in your Access database.

    Using DAO, you could change the Connect property of the linked tables. If you want to use ADO, someone else will probably have a suggestion.

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

    Re: Convert to SQL (2002 Access to SQL)

    <P ID="edit" class=small>(Edited by charlotte on 06-Sep-05 06:27. forgot attachment)</P>Sorry, but I don't see what this has to do with VB.Net since you don't use linked tables there at all. <img src=/S/confused.gif border=0 alt=confused width=15 height=20> You can certainly create table links with ADO, but did you want to use a class for that or just standard code?

    I'm attaching an old ADO routine that links a database or external files to an Access front end. The missing functions are pretty self-explanatory. Just don't try mixing DAO and ADO, either use ADO or built in functions and methods to return information to the ADO routine.
    Charlotte

Posting Permissions

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