?
Solved

DataControl connecting to Paradox 4.0 Table

Posted on 2000-05-15
6
Medium Priority
?
275 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
[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
  • 3
  • 3
6 Comments
 
LVL 10

Expert Comment

by:paasky
ID: 2811529
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
ID: 2811788
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 300 total points
ID: 2812257
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:davb
ID: 2814315
Adjusted points from 50 to 75
0
 

Author Comment

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

Expert Comment

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

Best regards,
Paasky
0

Featured Post

Technology Partners: 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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
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…
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

752 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