?
Solved

Selected collating sequence not supported

Posted on 2000-02-26
12
Medium Priority
?
1,488 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
[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
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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 150 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

719 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