Can you asynchronously open an access 97 table?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Can you asynchronously open an access 97 table?

  1. #1
    Robert C. Cain Guest

    Can you asynchronously open an access 97 table?

    Howdy,

    I am using ADO to open a recordset to an access 97 table. I'm having to
    generate the query on the fly based on user selections. Because it can
    return a large number of records, I'd like to be able to open the recordset
    using an asynchronous fetch so that I can use the FetchProgress event of the
    recordset to let the user know how it's going.

    Problem is even when I pass the correct parameters, it still does not open
    asynchronously but synchronously. I am beginning to suspect that Access 97
    does not support this, but can't find anything in the MSDN that tells me
    definitely one way or the other.

    I'd appreciate any information anyone has on this.

    Thanks,

    Robert



  2. #2
    Paul Clement Guest

    Re: Can you asynchronously open an access 97 table?

    On Wed, 9 May 2001 14:49:20 -0500, "Robert C. Cain" <robert.cain@comsys.com> wrote:

    Howdy,

    I am using ADO to open a recordset to an access 97 table. I'm having to
    generate the query on the fly based on user selections. Because it can
    return a large number of records, I'd like to be able to open the recordset
    using an asynchronous fetch so that I can use the FetchProgress event of the
    recordset to let the user know how it's going.

    Problem is even when I pass the correct parameters, it still does not open
    asynchronously but synchronously. I am beginning to suspect that Access 97
    does not support this, but can't find anything in the MSDN that tells me
    definitely one way or the other.

    I'd appreciate any information anyone has on this.

    Thanks,

    Robert


    I have to admit I've never tried this but, unless someone knows different, I would suspect that the
    threading model of Jet (database engine) wouldn't support this feature.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  3. #3
    Robert Gelb Guest

    Re: Can you asynchronously open an access 97 table?

    I also heard that the OLEDB Jet 3.51 provider is not thread-safe. Try using
    the OLEDB Jet 4.0 provider and see what happens.

    --
    Robert Gelb
    www.vbRad.com
    Source, Tips, Tricks, Components

    "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
    news:atajftkb55m99p0lbbtb3aif3a517mgb2n@4ax.com...
    > On Wed, 9 May 2001 14:49:20 -0500, "Robert C. Cain"

    <robert.cain@comsys.com> wrote:
    >
    > Howdy,
    >
    > I am using ADO to open a recordset to an access 97 table. I'm having to
    > generate the query on the fly based on user selections. Because it can
    > return a large number of records, I'd like to be able to open the

    recordset
    > using an asynchronous fetch so that I can use the FetchProgress event of

    the
    > recordset to let the user know how it's going.
    >
    > Problem is even when I pass the correct parameters, it still does not

    open
    > asynchronously but synchronously. I am beginning to suspect that Access

    97
    > does not support this, but can't find anything in the MSDN that tells me
    > definitely one way or the other.
    >
    > I'd appreciate any information anyone has on this.
    >
    > Thanks,
    >
    > Robert
    >
    >
    > I have to admit I've never tried this but, unless someone knows different,

    I would suspect that the
    > threading model of Jet (database engine) wouldn't support this feature.
    >
    >
    > Paul ~~~ pclement@ameritech.net
    > Microsoft MVP (Visual Basic)




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