Linking to DBASE tables

[MontainDoctor]

Hi Folks

I have a database in dbase. The dbf tables have numerous indexes
because of which the linking is not possible. What to do?

Rakesh

[HK]

Do you mean that one table has multiple keys or indexes? In Access,
when you connect using ODBC link tables, you can select multiple fields
as your primary key. I don't think Access will use your Foxpro
indexes.

I'm not well versed in this, but I think Foxpro (and Dbase maybe) view
a key and an index as unseperable objects. I believe Access sees these
two as totally seperate objects. Is this perception correct?

[Michael Juul Hansen]

do you use native or ODBC drivers to access the dBase table(s)?
"MontainDoctor" <dr************@gmail.com> skrev i en meddelelse
news:11**********************@t31g2000cwb.googlegr oups.com...

Hi Folks

I have a database in dbase. The dbf tables have numerous indexes
because of which the linking is not possible. What to do?

Rakesh

[MontainDoctor]

Dear Michael

I use native drivers to access dbase.

Rakesh

[Bri]

MontainDoctor wrote:

Hi Folks

I have a database in dbase. The dbf tables have numerous indexes
because of which the linking is not possible. What to do?

If I recall correctly, when you link, you are prompted for the index
file after you select the dbf file.

--
Bri

[Fred Zuckerman]

"Bri" <no*@here.com> wrote in message news:oTa2g.56385$7a.37382@pd7tw1no...

MontainDoctor wrote:

Hi Folks

I have a database in dbase. The dbf tables have numerous indexes
because of which the linking is not possible. What to do?

If I recall correctly, when you link, you are prompted for the index
file after you select the dbf file.

--
Bri

The index files are used by other applications (ie: dBase, Clipper,
xHarbour, etc). I think you can link to the dBase tables but if you add
records, delete records, or change fields that are part of an index key;
then you may disrupt those other applications because the index files would
no longer be accurate. Normally, the other applications should have a
re-indexing feature. The critical part is how do you notify the other
applications that re-indexing is needed....
Fred Zuckerman