Solved

DataControl connecting to Paradox 4.0 Table

Posted on 2000-05-15
6
268 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
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 75 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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…
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…

860 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