asked on

DataControl connecting to Paradox 4.0 Table

I have designed a simple little VB form with a datacontrol on it. This DataControl is then connected with the following settings:
Connect: Paradox 4.x
Default Type: UseJet
When I try and link this datacontrol to a text box, I get an error message
Incorrect Collating Sequence.
I can connect a Paradox 3.5 table in the same fashion, with no problems. I am sure it has something to do with how my Paradox 4.0 is setup compared to my Paradox 3.5? Any suggestions.

paasky

Hello davb,

This sounds regional/language (sorting) setting problem. See more information and resolution from these MS KB articles:

http://support.microsoft.com/support/kb/articles/Q184/9/88.ASP?LN=EN-US&SD=gn&FR=0

http://support.microsoft.com/support/kb/articles/Q133/3/81.asp?LN=EN-US&SD=gn&FR=0

Regards,
Paasky

davb

ASKER

I have compared the Paradox 3.5 table with the Paradox 4.0 table and have found that both are sorted the same way, and both have most of the same settings. The Paradox 3.5 table will work no problems, but the Paradox 4.0 table will not.

ASKER CERTIFIED SOLUTION

paasky

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

davb

ASKER

Adjusted points from 50 to 75

davb

ASKER

Thank you for your excellent solution. It worked like a charm!!

paasky

Glad I was able to help and thank you for extra points. :o)

Best regards,
Paasky