Linked dBase Table in Access2000


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Linked dBase Table in Access2000

  1. #1
    Jeff Moore Guest

    Linked dBase Table in Access2000

    I have an Access97 application with one linked dBase table. This dBase table
    is the datasource for another program we use to publish orders (FormFlow
    Filler). We create and track duty with the Access97 application, write
    appropriate order information into the dBase table with it, and then batch
    publish all the new orders from FormFlow.

    I recently upgraded the application to Office2000 and made all the
    appropriate DAO reference and coding changes. The form used to write to the
    linked dBase table, however, now gives me a runtime "Recordset not
    updateable." error. In fact, trying to edit records directly in the table
    also gives me this warning. I tried deleting the link and then relinking,
    and noticed a strange new issue under Access2000 -- the table links but
    without ever taking you to the option for selecting the appropriate dBase
    index file(s). I am guessing this is where my problem is.

    - How do I make a linked dBase table in Access2000 updateable?

    - How can I force the connection string for the dBase table to use the
    appropriate dBase index file, or coax Access2000 into asking for this file
    during the linking process.

    Thanks,
    Bandit292@msn.com





  2. #2
    Paul Clement Guest

    Re: Linked dBase Table in Access2000

    On Wed, 5 Jun 2002 01:49:49 -0400, "Jeff Moore" <SPAMFILTER_Bandit292@msn.com> wrote:

    I have an Access97 application with one linked dBase table. This dBase table
    is the datasource for another program we use to publish orders (FormFlow
    Filler). We create and track duty with the Access97 application, write
    appropriate order information into the dBase table with it, and then batch
    publish all the new orders from FormFlow.

    I recently upgraded the application to Office2000 and made all the
    appropriate DAO reference and coding changes. The form used to write to the
    linked dBase table, however, now gives me a runtime "Recordset not
    updateable." error. In fact, trying to edit records directly in the table
    also gives me this warning. I tried deleting the link and then relinking,
    and noticed a strange new issue under Access2000 -- the table links but
    without ever taking you to the option for selecting the appropriate dBase
    index file(s). I am guessing this is where my problem is.

    - How do I make a linked dBase table in Access2000 updateable?

    - How can I force the connection string for the dBase table to use the
    appropriate dBase index file, or coax Access2000 into asking for this file
    during the linking process.


    See the following:

    http://support.microsoft.com/default...;EN-US;q230125


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

  3. #3
    Jeff Moore Guest

    Re: Linked dBase Table in Access2000

    Worked like a champ. Thanks for the pointer. Not sure how I missed it on my
    first pass through the MS site for answers.

    Jeff



    "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
    news:l9vr***vt0qm0thdlakooqqlpplae89ga5@4ax.com...
    > On Wed, 5 Jun 2002 01:49:49 -0400, "Jeff Moore"

    <SPAMFILTER_Bandit292@msn.com> wrote:
    >
    > I have an Access97 application with one linked dBase table. This dBase

    table
    > is the datasource for another program we use to publish orders (FormFlow
    > Filler). We create and track duty with the Access97 application, write
    > appropriate order information into the dBase table with it, and then

    batch
    > publish all the new orders from FormFlow.
    >
    > I recently upgraded the application to Office2000 and made all the
    > appropriate DAO reference and coding changes. The form used to write to

    the
    > linked dBase table, however, now gives me a runtime "Recordset not
    > updateable." error. In fact, trying to edit records directly in the

    table
    > also gives me this warning. I tried deleting the link and then

    relinking,
    > and noticed a strange new issue under Access2000 -- the table links but
    > without ever taking you to the option for selecting the appropriate

    dBase
    > index file(s). I am guessing this is where my problem is.
    >
    > - How do I make a linked dBase table in Access2000 updateable?
    >
    > - How can I force the connection string for the dBase table to use

    the
    > appropriate dBase index file, or coax Access2000 into asking for this

    file
    > during the linking process.
    >
    >
    > See the following:
    >
    > http://support.microsoft.com/default...;EN-US;q230125
    >
    >
    > 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