If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

Re: 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.
¤

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)