[dirty resolved...] Weird problem on SELECT * FROM X;

[Fox]

Hi, I got a huge problem when getting data out of my table. It's a huge one because the code works for any table except one.

I'm calling the .Execute function which returns a RecordsAffected of 2 which is true because there are 2 records in my table. I also check for .state being adStateOpen. Then I'm checking for .BOF and .EOF and the weird thing is that they both are set to True! And as mentioned before, the same code works perfectly fine when getting records from another table.

The code looks like this:

Set Results = Connection.Execute("SELECT * FROM banlist;", Count)
    '## Count is 2 at this point
 
    'MsgBox Results.RecordCount
    '## Gettin Error -2147467259 "Provider returned E_FAIL" here
    
    If Results.State = adStateOpen Then
        If Not (Results.EOF And Results.BOF) Then: Results.MoveFirst
        '## If I skip the EOF/BOF check the same error
        '## -2147467259 is raised here
    End If

Of course I can't access the data after this, but I guess the data was transferred because Count returned 2 as it should...

I'm running out of ideas here...

[Fox]

I tried dropping the table and adding the values one for one again. I noticed the code works fine unless the table contains more than 1 datetime or timestamp column. Any other data types work fine.

*any* ideas?