Solved

Selected collating sequence not supported

Posted on 2000-02-26
12
1,456 Views
Last Modified: 2012-05-07
I want to open an Access database in German windows that was created in English windows. I get the error message 'selected collating sequence not supported by the operating system'.
The Help file doesn't help, because there isn't a Paradox key in the Windows registry. At least not where the Help file says it should be.

Does anyone have a solution to this problem?
0
Comment
Question by:Richard3
12 Comments
 
LVL 12

Expert Comment

by:Trygve
ID: 2561909
Create a file called FixCollatingProblem1.Reg and copy/paste this into it

REGEDIT4

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

Then create another file called FixCollatingProblem2.Reg and copy/paste this into it

REGEDIT4

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

Now, try running the second one by doubleclicking on it, restart the machine and it should work. If that did not help, run the other file.

Now later on, if you get the problem run the file that changes the registry key.
0
 
LVL 12

Expert Comment

by:Trygve
ID: 2561910
Access somehow needs this key to be able to read those "foreign" tables. I get this problem every time I receive MDBs from Sweden, which should be similar enough to my Norwegian tables...

You can also go directly into the registry and set the key if you are familiar with RegEdit. Remember to restart.
0
 
LVL 9

Expert Comment

by:BrianWren
ID: 2562032
What a pain...  I guess if you know what to do none of it's really hard, but still, what a pain...
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 12

Expert Comment

by:Trygve
ID: 2563856
Copy/Paste into a file with a spesified name and the execute the file can't be that hard? But I know what you mean, why do MS give us these puzzles? What effect should a Paradox setting have on Access?
0
 

Author Comment

by:Richard3
ID: 2564398
Thanks Trygve

but I went into regedit and like I said there was no Paradox key in my German windows - there isn't in my English windows either. I made a key, called it "Paradox" and gave it a string value "CollatingSequence" = "International". It didn't work so I changed it to Ascii. Again no luck.
There was a key called Xbase with a "CollatingSequence" so I changed that to. Didn't work.

I made this database in English NT4.
It works in Polish win95 but not in German or Dutch win95. My customers there need to use it and they know even less about windows registery than I do.

I think I'll have to reconstruct the database in German windows and import the data using Excel files.
I don't know so much about Databases but all this seems pretty ridiculous to me.
0
 
LVL 12

Expert Comment

by:Trygve
ID: 2564597
Did you restart between each attempt? If you forgot then try again.
0
 

Author Comment

by:Richard3
ID: 2565068
Yes, several times
0
 
LVL 12

Expert Comment

by:Trygve
ID: 2566270
Are your application MDB set up with "General" as the Database sort order? If not, you can get problems as the different language versions will try to force their sorting on the data.
0
 
LVL 12

Accepted Solution

by:
Trygve earned 50 total points
ID: 2566276
Also: Are the tables linked into the application MDB or do you keep all objects within one MDB

If you have one MDB, then you should try moving the non-table-objects into a separate MDB, link the tables from the table-mdb and then copy the application MDB to your clients computers.
0
 

Author Comment

by:Richard3
ID: 2566746
Thank you Trygve

You have helped me in a round about way to a working database in English and German windows.
I don't think linking the tables will help because my clients aren't connected to my computer. However by simply copying all the tables, queries and forms into a new database it now works in German windows whether the "CollatingSequence" is set to "Ascii" or "International". I checked the sort order and it was set to "Polish". Copying and pasting into a new database works if it's set to "Polish" or "General"
0
 
LVL 12

Expert Comment

by:Trygve
ID: 2567786
Good for you!
0
 
LVL 1

Expert Comment

by:ikeait
ID: 26162089
Hello all.

I had this problem with a program I received with sound level meter I got.  Program called VoiceLAB from Smartsensor, meter called AR834.

I did not get this to work, no mater what I changed in the registry, first error was a strange MDAC error, regarding 2.80 or 2.81, even found Windows XP SP1 to test on, still not working.  The I installed Office 2003 and 2007, no matter.

Finally, I just opened the database in Office 2007, saved it again under a diffrent name in a Access 2000 format.  Worked like a charm.  

Hope this helps somebody... :)

Regards,
Olvir Sveinsson
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

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…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

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