Disparate record counts

[Mark]

A disparity exists between record counts when viewing the same table in
Access (2002 mdb linked to 2000 SQL Server) and viewing the record count by
right clicking the table in Enterprise Manager and selecting ‘Properties’. I
can flush a table and it will show 0 records in Access but still shows 42
rows from Enterprise Manager. I populate the table and it shows 10,576
records from Access and 10,618 viewed in EM. Can anyone explain why there is
this disparity?

Thanks,

Mark

 

[Jeff Boyce]

Mark

How are you determining "record count" in Access? If you are using an
"autonumber" field, be aware that these may not be sequential, so the "last"
autonumber value may not be the actual record count.

I don't know how you are "flushing" a table, so I don't have any ideas why
SQL-Server/Enterprise Manager would (still) show 42 rows. Can you print out
the rows from Enterprise Manager and look them over for a common pattern?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mark]

How are you determining "record count" in Access? If you are using an
"autonumber" field, be aware that these may not be sequential, so the "last"
autonumber value may not be the actual record count.

Opening the table and navigating to the last record.

I don't know how you are "flushing" a table, so I don't have any ideas why
SQL-Server/Enterprise Manager would (still) show 42 rows. Can you print out
the rows from Enterprise Manager and look them over for a common pattern?

I can delete the records from Access manually, or by way of a SP in EM. I
ask all rows be returned and I don't see any records. If I right click and
select Properties, I get the 42 records.
? Thanks,
Mark

 

[Jeff Boyce]

Mark

If I'm using an autonumber field and I navigate to the "last" record, I can
look at the autonumber field for a value, or I can look at the navigation
section in the bottom left. Which one are you using to determine the
"count"?

As for your "ghost" 42 rows (according to properties), I haven't run into
that. If I open the table and see no rows, I've always just assumed there
were none. Now I'll have to go back to the drawing board and reconsider!

Perhaps one of the other newsgroup readers has run across this?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mark]

Mark

If I'm using an autonumber field and I navigate to the "last" record, I can
look at the autonumber field for a value, or I can look at the navigation
section in the bottom left. Which one are you using to determine the
"count"?

The navigation section in the bottom left in Access. It's the row count in
EM that shows 42 but when I ask all records be returned, there are none...

As for your "ghost" 42 rows (according to properties), I haven't run into
that. If I open the table and see no rows, I've always just assumed there
were none. Now I'll have to go back to the drawing board and reconsider!

My assumption as well. It is perplexing that the 'Properties' show 42 rows.
My world is must be logical or I risk all out insanity.
Thanks Jeff.
M