Solved

Attached FoxPro 2.5 table index ".cdx" problem!

Posted on 1998-01-07
2
424 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
2 Comments
 

Author Comment

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

Accepted Solution

by:
cymbolic earned 150 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 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