Jet engine loses 10 records when first opening an Access 97 database 
Author Message
 Jet engine loses 10 records when first opening an Access 97 database

Try:
rs.MoveLast
rs.MoveFirst

Then, check the RecordCount.

--



Quote:
> 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...



Fri, 05 Nov 1999 03:00:00 GMT  
 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.


Sat, 06 Nov 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Accessing a password protected Access 97 database using the Jet Engine

2. losing records when first reading an Access database

3. Microsoft Jet Database Engine Cannot Open The File.......(access)mdb

4. Microsoft Jet Database Engine Cannot Open The File.......(access)mdb

5. Access 97 Tables are not being seen by Jet DB Engine But they are there

6. Help wtd: losing key values in Jet database engine

7. Display the First 10 records of a Query/Report only

8. Select first 10 records in SQL Server 6.5?

9. Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

10. Mod 10 Check Routine using VB for Access 97

11. The Microsoft Jet database engine cannot open the file

12. The Microsoft Jet database engine cannot open the file

 

 
Powered by phpBB® Forum Software