UtterAccess Discussion Forums > Fewer records returned in Access linked table

Full Version: Fewer records returned in Access linked table

UtterAccess Discussion Forums > Microsoft® Access > Access Tables + Relationships

mrpogle23

Aug 29 2007, 05:45 PM

I am running SQL server and Access on the same machine and both have ODBC connections to the same table. When I do a Select Count(RECID) FROM etc in SQL Server I get about 1.5 million records but when I do exactly the same thing in Access I get about 460,000 records (with the most recent not being present when I group on a date when the record was added).

Why?

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.