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?
