Collating sequence not supported...

[Bregalad]

I have an Access 97 database that I'm using ADO in VB6 to
communicate with.

Most of the time the application works fine, but sometimes
I get an error saying "Selected collating sequence not
supported by the operating system".

This prevents me from connecting to the database until I
have rebooted my computer and reopened my project in VB.

I use the following code to connect:

Dim cn As Connection
Dim rs As New Recordset

with cn
.ConnectionString = "Provider=Microsoft.JET.OLEDB.3.51;Data Source=" & sPath
.CursorLocation = adUseClient
.Open
end with
'sPath is a string containing the path to my Access db

The error occurs before i try to open a recordset, so it
has to be something in this first part of the code.

Any ideas what I'm doing wrong? Or is this a bug or some
sort of incompatibility between the Microsoft ActiveX
Data Objects 2.5 library and Access 97?

[Clunietp]

http://support.microsoft.com/support.../Q184/9/88.ASP