Access2.0 DB and VB4-16bit
This behavior is by design. To get an accurate recordcount, perform a =
movelast on the recordset. The recordcount should then reflect the =
correct number.
--
David W. Forest
LAN Specialist
Information Technologies
Lear Corporation - Ford Division
SBN Level 2
http://www.concentric.net/~dforest/
If you're not scared, you don't understand.
Matthias Waltsgott wrote in article =
Quote:
>Hi all,
>I've a problem with VisualBAsic 4.0 16-bit and Access 2.0
>When I want to access the database with
> sql =3D "SELECT * FROM table WHERE ..."
> set mytable =3D mydatabase.OpenRecordset(sql, dbOpenDynaset)
>the result is only the first record from the table matching the
>sql-query and the whole result (mytable.RecordCount) is 1. I can acces
>the table with
> set mytable =3D mydatabase.OpenRecordset(tablename, dbOpenTable)
>and everything works fine. But If I want to open the table with
>'dbOpenDynaset' or 'dbOpenSnapshot' the result is only the first =
record.
>And there is no error or warning message. I don't know what's the
>problem.
>Hope someone could help me.
>Thx in advance.
>CU
>Matthias
>--
>Matthias Waltsgott
>Fakultaet Wirtschaftswissenschaften
>Studiengang Wirtschaftsinformatik
>Technische Universitaet Ilmenau
>=20
