DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: using sql & ado to create a database

  1. #1
    dan Guest

    using sql & ado to create a database


    hi,
    developing an interactive website and need to build a database for registered
    users. can do this in dao but have yet to find ado method. i am using vb6
    and have access 2000.
    thanks

  2. #2
    Douglas J. Steele Guest

    Re: using sql & ado to create a database

    You need to use ADOX, not ADO.

    http://www.able-consulting.com/ADOX_Faq.htm#Q2 at Carl Prothman's site
    specifically shows how to create an Access database.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele


    "dan" <dangibbs@cox-internet.com> wrote in message
    news:3d4e2aa7$1@10.1.10.29...
    >
    > hi,
    > developing an interactive website and need to build a database for

    registered
    > users. can do this in dao but have yet to find ado method. i am using vb6
    > and have access 2000.
    > thanks




  3. #3
    MarkN Guest

    Re: using sql & ado to create a database


    If memory serves me - you will only need ADOX to create the Access database.
    Once you connect, you can then send DDL via ADO. So if you don't want to
    deal with ADOX then you can have a blank Access DB, copy and rename it and
    then send DDL statements.



    "Douglas J. Steele" <djsteele@canada.com> wrote:
    >You need to use ADOX, not ADO.
    >
    >http://www.able-consulting.com/ADOX_Faq.htm#Q2 at Carl Prothman's site
    >specifically shows how to create an Access database.
    >
    >--
    >Doug Steele, Microsoft Access MVP
    >http://I.Am/DougSteele
    >
    >
    >"dan" <dangibbs@cox-internet.com> wrote in message
    >news:3d4e2aa7$1@10.1.10.29...
    >>
    >> hi,
    >> developing an interactive website and need to build a database for

    >registered
    >> users. can do this in dao but have yet to find ado method. i am using

    vb6
    >> and have access 2000.
    >> thanks

    >
    >



  4. #4
    Douglas J. Steele Guest

    Re: using sql & ado to create a database

    That's more or less correct. I'm not sure that every property is supported
    through DDL statements, but you can probably do most of it that way.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele


    "MarkN" <m@n.com> wrote in message news:3d4fbdf4$1@10.1.10.29...
    >
    > If memory serves me - you will only need ADOX to create the Access

    database.
    > Once you connect, you can then send DDL via ADO. So if you don't want to
    > deal with ADOX then you can have a blank Access DB, copy and rename it and
    > then send DDL statements.
    >
    >
    >
    > "Douglas J. Steele" <djsteele@canada.com> wrote:
    > >You need to use ADOX, not ADO.
    > >
    > >http://www.able-consulting.com/ADOX_Faq.htm#Q2 at Carl Prothman's site
    > >specifically shows how to create an Access database.
    > >
    > >--
    > >Doug Steele, Microsoft Access MVP
    > >http://I.Am/DougSteele
    > >
    > >
    > >"dan" <dangibbs@cox-internet.com> wrote in message
    > >news:3d4e2aa7$1@10.1.10.29...
    > >>
    > >> hi,
    > >> developing an interactive website and need to build a database for

    > >registered
    > >> users. can do this in dao but have yet to find ado method. i am using

    > vb6
    > >> and have access 2000.
    > >> thanks

    > >
    > >

    >




  5. #5
    MarkN Guest

    Re: using sql & ado to create a database


    Yeah. I can't say for sure what is not - but I was able to create everything
    I needed to include relationships, indexes, etc. I never had any problem.
    Actually doing it through DDL I was able to avoid the problem Access has
    with not allowing nulls (can't remember exactly the scenario). If anyone
    went in and played with the tables via Access then it would screw up.

    So I guess I don't know what would be more or less. I had a blank DB. I
    created tables, relationships, keys and indexes - everything I needed.


    "Douglas J. Steele" <djsteele@canada.com> wrote:
    >That's more or less correct. I'm not sure that every property is supported
    >through DDL statements, but you can probably do most of it that way.
    >
    >--
    >Doug Steele, Microsoft Access MVP
    >http://I.Am/DougSteele
    >
    >
    >"MarkN" <m@n.com> wrote in message news:3d4fbdf4$1@10.1.10.29...
    >>
    >> If memory serves me - you will only need ADOX to create the Access

    >database.
    >> Once you connect, you can then send DDL via ADO. So if you don't want

    to
    >> deal with ADOX then you can have a blank Access DB, copy and rename it

    and
    >> then send DDL statements.
    >>
    >>
    >>
    >> "Douglas J. Steele" <djsteele@canada.com> wrote:
    >> >You need to use ADOX, not ADO.
    >> >
    >> >http://www.able-consulting.com/ADOX_Faq.htm#Q2 at Carl Prothman's site
    >> >specifically shows how to create an Access database.
    >> >
    >> >--
    >> >Doug Steele, Microsoft Access MVP
    >> >http://I.Am/DougSteele
    >> >
    >> >
    >> >"dan" <dangibbs@cox-internet.com> wrote in message
    >> >news:3d4e2aa7$1@10.1.10.29...
    >> >>
    >> >> hi,
    >> >> developing an interactive website and need to build a database for
    >> >registered
    >> >> users. can do this in dao but have yet to find ado method. i am using

    >> vb6
    >> >> and have access 2000.
    >> >> thanks
    >> >
    >> >

    >>

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center