By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,238 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,238 IT Pros & Developers. It's quick & easy.

Missing data???

P: 57
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 !!!!
Feb 12 '08 #1
Share this Question
Share on Google+
6 Replies


puppydogbuddy
Expert 100+
P: 1,923
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?
Feb 12 '08 #2

P: 57
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?
Thanks for the reply. I did delete the link to that specific computer and relink it again, but the records still 20212. I can't open the table through the database it gave me an error saying "odbc call failed", but when I tried creating the query for the count, it gave me the records still 20212. The records should've been 20290. I updated the MDAC. Should I reinstall access 2003?
Feb 12 '08 #3

puppydogbuddy
Expert 100+
P: 1,923
Thanks for the reply. I did delete the link to that specific computer and relink it again, but the records still 20212. I can't open the table through the database it gave me an error saying "odbc call failed", but when I tried creating the query for the count, it gave me the records still 20212. The records should've been 20290. I updated the MDAC. Should I reinstall access 2003?
May,

I would not reinstall Access 2003 just yet. Next I would check the max records property setting for the Access query that you used to obtain the record count on the linked table and verify that is >= to the server count. To check the max records property, place the query in design view, right click in the table area, but not on a table. On the shortcut menu, select properties, then page down to max records. The following link explains more detail and has a function to test how max records is operating when nothing has been set for that property.

http://support.microsoft.com/kb/207621#top
Feb 13 '08 #4

puppydogbuddy
Expert 100+
P: 1,923
May,
I found this on one of the public forums. Hope it helps.

Record Counts in SQL Server Table
Reply from Bryan Schoen on 4/5/2005 5:49:00 PM

I have found that you can not rely 100% on the record counts that shows up
in EM under the table properties. The counts that are displayed there come
from the sysindexes table.

Run the command DBCC UPDATEUSAGE to correct this problem. Look in BOL for the syntax.
Feb 13 '08 #5

P: 57
May,
I found this on one of the public forums. Hope it helps.

Record Counts in SQL Server Table
Reply from Bryan Schoen on 4/5/2005 5:49:00 PM

I have found that you can not rely 100% on the record counts that shows up
in EM under the table properties. The counts that are displayed there come
from the sysindexes table.

Run the command DBCC UPDATEUSAGE to correct this problem. Look in BOL for the syntax.
I found out what's going on. There's an error on the ms access driver on that specific computer. What I need to do is recreate the ms access driver and that's solved the problem.
Feb 18 '08 #6

puppydogbuddy
Expert 100+
P: 1,923
I found out what's going on. There's an error on the ms access driver on that specific computer. What I need to do is recreate the ms access driver and that's solved the problem.
May,
Glad you got it resolved. Thanks for posting back and letting us know what the final resolution was.
Feb 18 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.