Solved

Selected collating sequence not supported

Posted on 2000-02-26
12
1,459 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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…
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.

856 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