Sorry for any crossposts, but perhaps the solution for this can be solved using
ODBC. Thanks for any help
I'm trying to retrieve a selected recordset from a paradox table with the
following SQL Statement:
strSQL="SELECT * FROM [GROUP] WHERE [Grp] = '1'"
the recordopening looks like this:
rsCheckRecord.Open strSQL, cnnCentralDB , adOpenForwardOnly, adLockBatchOptimistic
and the connection looks like this:
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
mstrDataPath & _
";Extended Properties=Paradox 4.x;"
Set cnnCentralDB = New ADODB.Connection
cnnCentralDB.Open strConnection ' Set the Central Database
I can open recordsets with the connection, but as soon as I use a *WHERE* clause
in the SQL statement, I get the error:
'Operation not supported on a Paradox table without a Primary Key.'
Seems like I should be able to filter out the records I want without having a
primary key. Any ideas on how to solve or work around this? Thanks in advance
to respond directly, remove ~NOSPAM~ from the email address