Jet engine loses 10 records when first opening an Access 97 database
Quote:
> Tried it... the rs.recordcount is still 10 records short :(
> > Try:
> > rs.MoveLast
> > rs.MoveFirst
> > Then, check the RecordCount.
> > --
> > > I'm using VB5 Enterprise and am using the jet engine to read an Access
> > > 97 database. When looking at the database in Access 97, there's 119
> > > records in total. Just after opening the recordset in VB, I do a
> > > debug.print .recordcount and it tells me that there's a total of 109
> > > records... The last 10 records have completely disappeared. To my
> > > mind, this is not good. I have gotten 1 reply back on
> > > comp.lang.basic.visual.misc saying that this "feature" was also present
> > > in VB4, but not if there's either a work-around or a bug-fix (he doesn't
> > > know).
> > > Can anyone help me out with this...
I ran into something like this also. It wasn't with an Access 97 though
but using Jet 3.5 & VB5. If your DB gets fragmented you can't trust the
record count. Try repairing and compacting to see if this solves the
problem. I don't know how Paul Clement ever figured this one out but
I'm glad he posted a solution.
