471,612 Members | 1,934 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,612 software developers and data experts.

FoxPro index problems with Access

I have a customer that is using Access to create reports from FoxPro
tables. We started noticing problems with the indexes on the FoxPro
tables. It is to the point where we have to delete and rebuild the
indexes on a nightly basis. We cannot determine if Access is the
culprit and I have not been able to look at the Access reports and
determine how he is linking to the tables. I realize this is not much
to go on, but does anyone see any possible problems that might result
from linking Access to FoxPro tables? Any suggestions would be greatly
appreciated. Thanks.
Nov 12 '05 #1
1 2209
jd*********@appliedsystems.com (jdola) wrote in
news:3e**************************@posting.google.c om:
I have a customer that is using Access to create reports from
FoxPro tables. We started noticing problems with the indexes
on the FoxPro tables. It is to the point where we have to
delete and rebuild the indexes on a nightly basis. We cannot
determine if Access is the culprit and I have not been able to
look at the Access reports and determine how he is linking to
the tables. I realize this is not much to go on, but does
anyone see any possible problems that might result from
linking Access to FoxPro tables? Any suggestions would be
greatly appreciated. Thanks.

I have several Foxpro tables that I read from Access. Compound
indexes (.cdx) files are not subject to any issues due to linking
from Access in my experience, but .idx or .ndx files are subject to
all sorts of little problems, like the developer failing to
maintain them, users failing to open them.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sveta Tsybizova | last post: by
1 post views Thread by Steve Perry | last post: by
13 posts views Thread by Simon Bailey | last post: by
2 posts views Thread by Maverick | last post: by
1 post views Thread by ray well | last post: by
7 posts views Thread by z71mdridin | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by CCCYYYY | last post: by
1 post views Thread by ZEDKYRIE | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.