Solved

DataControl connecting to Paradox 4.0 Table

Posted on 2000-05-15
6
265 Views
Last Modified: 2012-05-04
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.
0
Comment
Question by:davb
  • 3
  • 3
6 Comments
 
LVL 10

Expert Comment

by:paasky
Comment Utility
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
0
 

Author Comment

by:davb
Comment Utility
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.
0
 
LVL 10

Accepted Solution

by:
paasky earned 75 total points
Comment Utility
You could try changing the registry collating order setting. Copy/paste these to own text files and double click the file to change the settings.

reg1.reg:
--------------------------------------------------------------------------------
REGEDIT4

[HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\Engines\Paradox]
"CollatingSequence"="Ascii"

reg2.reg:
--------------------------------------------------------------------------------
REGEDIT4

[HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\Engines\Paradox]
"CollatingSequence"="International"
--------------------------------------------------------------------------------

Note that you need to re-start your computer before the change take effect.

Regards,
paasky
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:davb
Comment Utility
Adjusted points from 50 to 75
0
 

Author Comment

by:davb
Comment Utility
Thank you for your excellent solution.  It worked like a charm!!
0
 
LVL 10

Expert Comment

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

Best regards,
Paasky
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

743 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now