You receive a "Selected Collating Sequence Not Supported" error message in Access 2000 (202150)
The information in this article applies to:
This article was previously published under Q202150 For a Microsoft Access 97 version of this article,
see
184988. Novice: Requires knowledge of the user interface on single-user
computers. This article applies only to a Microsoft Access database (.mdb).
SYMPTOMS When you try to open a database or an object in a database
(such as a table or a form), or when you try to compact a database, you may
receive one of the following error messages: Selected
collating sequence not supported by the operating system. Invalid collating sequence. Unrecognized database format
'<pathname>\<filename>'. CAUSE One of the following conditions is true: - You are trying to open a database or an object in a
database that was created in another language edition of Microsoft Access.
- You are trying to open a database that was created or
compacted while the New Database Sort Order was set to a value other than
General.
To check the setting of the New Database Sort Order, follow
these steps: - Open an existing database that was not created or compacted
while the Sort Order was set to a value other than General. For example, open
the sample database Northwind.mdb.
- On the Tools menu, click Options, and then click the General tab.
- Make sure that the New Database Sort Order is set to General and then click OK.
If you are
receiving the errors described in the "Symptoms" section, setting the New
Database Sort Order back to General does not resolve the problem; however, it
prevents the problem from occurring with new databases.
RESOLUTION Install or enable multilanguage support for your operating
system. NOTE: Even if you install multilanguage support, you cannot
open a database if it requires a code page that is not supported by your
operating system.
If the database was created in a language that uses a type
of character set supported by your operating system, you can open the database
after you have enabled support for multiple languages. To install
multilanguage support in Windows 95/98 or Windows NT, please follow the steps
in one of the following articles in the Microsoft Knowledge Base. NOTE: This feature is included in the CD-ROM version of Windows 95,
but not in the floppy disk version. If you are using the floppy disk version of
Windows 95 and you want to enable multilanguage support, please see the
following article in the Microsoft Knowledge Base: 135315 CD-ROM Extras for Microsoft Windows 95 Upgrade
141306 How to Enable Support for Multiple Languages in Windows
177561 HOWTO: Add and Enable Additional Languages in Windows NT
REFERENCES
| Modification Type: | Major | Last Reviewed: | 8/6/2004 |
|---|
| Keywords: | kbopenfile kbtshoot kberrmsg kbprb KB202150 |
|---|
|