By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 1,783 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

Linking to DBASE tables

P: n/a
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

Apr 20 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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?

Apr 20 '06 #2

P: n/a
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

Apr 20 '06 #3

P: n/a
Dear Michael

I use native drivers to access dbase.

Rakesh

Apr 21 '06 #4

P: n/a
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

Apr 21 '06 #5

P: n/a
"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
Apr 21 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.