From DAO to ADO


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: From DAO to ADO

  1. #1
    T. Bradley Dean Guest

    From DAO to ADO

    I'm in the process of switching a VB app's database from Access 97 to SQL 7.
    I upgrade the db to Access 2K, and then used the upsizing wizard to convert
    to SQL 7. Piece of cake.

    I changed all my VB code from DAO to ADO, but I have a few bugs. When I try
    to run :
    "Select * from tblReasons order by Index"
    I get the following error:
    Run-time error '-2147217887 (800040e21), The requested properties cannot be
    supported.
    If I change it to:
    "Select * from tblReasons"
    then it works fine.

    Also, .Edit is no longer available! How do I start editing a row?

    Any ideas?

    T. Bradley Dean
    Bradley.Dean@InfoDish.com



  2. #2
    Jeff Guest

    Re: From DAO to ADO


    to edit a row, just start changing values. no .edit required.


    "T. Bradley Dean" <Bradley.Dean@InfoDish.com> wrote:
    >I'm in the process of switching a VB app's database from Access 97 to SQL

    7.
    >I upgrade the db to Access 2K, and then used the upsizing wizard to convert
    >to SQL 7. Piece of cake.
    >
    >I changed all my VB code from DAO to ADO, but I have a few bugs. When I

    try
    >to run :
    >"Select * from tblReasons order by Index"
    >I get the following error:
    >Run-time error '-2147217887 (800040e21), The requested properties cannot

    be
    >supported.
    >If I change it to:
    >"Select * from tblReasons"
    >then it works fine.
    >
    >Also, .Edit is no longer available! How do I start editing a row?
    >
    >Any ideas?
    >
    >T. Bradley Dean
    >Bradley.Dean@InfoDish.com
    >
    >



  3. #3
    Anthony Jones Guest

    Re: From DAO to ADO

    Do you really have a column called Index???

    Try '... order by [Index]'


    --
    Anthony Jones
    Secta Group Ltd




  4. #4
    T. Bradley Dean Guest

    Re: From DAO to ADO

    Well, I tried it and it works, but if feels so wierd.

    I'm going to put this code before I change any values:

    '.Edit

    Ah, that's feels much better...

    Jeff <jeff@advancedtracker.com> wrote in message
    news:394a2129$1@news.devx.com...
    >
    > to edit a row, just start changing values. no .edit required.
    >
    >
    > "T. Bradley Dean" <Bradley.Dean@InfoDish.com> wrote:
    > >I'm in the process of switching a VB app's database from Access 97 to SQL

    > 7.
    > >I upgrade the db to Access 2K, and then used the upsizing wizard to

    convert
    > >to SQL 7. Piece of cake.
    > >
    > >I changed all my VB code from DAO to ADO, but I have a few bugs. When I

    > try
    > >to run :
    > >"Select * from tblReasons order by Index"
    > >I get the following error:
    > >Run-time error '-2147217887 (800040e21), The requested properties cannot

    > be
    > >supported.
    > >If I change it to:
    > >"Select * from tblReasons"
    > >then it works fine.
    > >
    > >Also, .Edit is no longer available! How do I start editing a row?
    > >
    > >Any ideas?
    > >
    > >T. Bradley Dean
    > >Bradley.Dean@InfoDish.com
    > >
    > >

    >




  5. #5
    T. Bradley Dean Guest

    Re: From DAO to ADO

    I know, I know. Bad choice of names. What can I say, it was late...

    Thanks, it worked great!

    Anthony Jones <yadayadayada@msn.com> wrote in message
    news:394af7c9$1@news.devx.com...
    > Do you really have a column called Index???
    >
    > Try '... order by [Index]'
    >
    >
    > --
    > Anthony Jones
    > Secta Group Ltd
    >
    >
    >




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