Hello,
(sorry for my bad english)

I tried to select records from table in Access database. I have VB 5.0 with
SP3.

The statement is:

set data1.recordset = database.openrecordset("Select A, B, C from tbname
where A=a order by C asc, D desc")

When lenght of string "Select ... " is smaller then 261, then it is OK. But
when lenght is bigger then 260, vb send message about error in string. Error
description is always the same, but string, which is shown in
err.description, not. If I want to create a select longer then 260, I must
use a querydef. There is no problem.

Does anybody know more about this problem?

Thanks.