Hi,
I have a weird problem. I have an access database (in access 2003) with a link table from SQL called log with total records 20290. The problem is some computers show the whole record on the database, some don't. It only shows 20212 records. How is it possible since they're sharing the same database? how to fix this problem? Please help !!!!
Hi May,
This advice is from post#16 of the following link. Hope it helps.
http://www.thescripts.com/forum/thread206626.html
--------------------------------------------------------------------------------
You could try a Count query to verify that the records are available
through the link or not.
SELECT Count(*) as TotalRecords FROM myTable
If this record count matched the record count on SQL Server, then it is
not the link, but some limit in what you are viewing the data from (see
David's post).
If the Count does not match the SQL count (and I assume matches the
count of your other viewing method) then something could be whacky with
the link. Have you tried deleting and recreating the link to see if that
makes a difference?