Linking to Foxpro 2.6

[LaDeana via AccessMonster.com]

I am trying to link a Foxpro 2.6 table to MS Access and be able to add and
delete records. This sounds like an easy task until you realize all the
obstacles that you have to jump through.

I'm able to link the table as a dBASE IV table and edit it, but my edits
are not being updated in the index file (cdx).

My linked table only updates the index file correctly if I link the table
through ODBC with a Machine datasource. Also I am prompted for the primary
keys.

I am trying to find a way to do this in code, but all my attempts have
resulted in errors. Since I can't use a file dsn to link the tables,
(Microsoft has confirmed this to be an issue) I need to programatically
define the machine dsn, and link the table using a connection string. I'll
also have to find a way to define my primary keys in code.

At this point the only option I have is to define the machine dsn on each
workstation manually and hope that the link to my tables stay intact.

Kudos to anyone who has the solution!!! Thanks for reading my post!

 

[Cindy Winegarden]

Hi LaDeana,

What makes you think the CDX index files are not being updated?

 

[LaDeana via AccessMonster.com]

My cdx file's datestamp remains the same even though the dbf file's date
stamp changes when adding or deleting records.

Also, The gui doesn't reflect any of the additions or deletions made to the
table through access, even though I can see these changes when looking
directly at the table.

If I can't get the indexes to work I am going to have use the oledb driver.
I'll need to rewrite much of my code to utilize temp tables foxpro.

Thanks for your help,
LaDeana

 

[Cindy Winegarden]

Hi LaDeana,

Just because the file timestamp doesn't change doesn't mean the indexes
aren't updated.

About the GUI not reflecting changes, which GUI - what are you looking at?
When you say you see the changes looking "directly at the table" do you mean
the table as opened on the Tables page of the Access MDB or using FoxPro to
open the table?