?
Solved

Attached FoxPro 2.5 table index ".cdx" problem!

Posted on 1998-01-07
2
Medium Priority
?
430 Views
Last Modified: 2011-10-03
I have a FoxPro 2.5 table ,Customer.dbf.  I have an Index "Customer.cdx" with 10 indexes in that file. When I attach the table to Access 2.0 it ask for an index file 'Customer.cdx' & it then asks for 'Select Unique Record Identifier'. It only displays 1 of the 10 indexes, Cust-New, and doesn't show the 9 other indexes.
I need one of the other index, 'Customer-I',  found within that Index file 'Customer.cdx'.
What am I doing wrong? Why aren't all 10 indexes showing up in the selection box? How can I use that index?
Also I'm unable to make any changes to the index file, Customer.cdx, as it is used by other programs.

Thank You.
0
Comment
Question by:ewalsh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:ewalsh
ID: 1964689
Adjusted points to 150
0
 
LVL 9

Accepted Solution

by:
cymbolic earned 300 total points
ID: 1964690
Unfortunately, it is not possible for Access to use an index that contains a complex expression, such as fld1+function(fld2), etc.

See Q122561 on MS Knowledge base if that is your problem.  There is no way around this, since the actual function is contained in Foxpro code, and not available to MS Access.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question