473,326 Members | 2,023 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Missing data???

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
6 3782
puppydogbuddy
1,923 Expert 1GB
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
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
1,923 Expert 1GB
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
1,923 Expert 1GB
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
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
1,923 Expert 1GB
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

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

Similar topics

4
by: SQLJunkie | last post by:
Here is an issue that has me stumped for the past few days. I have a table called MerchTran. Among various columns, the relevant columns for this issue are: FileDate datetime , SourceTable...
7
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting list. But there isn't any information available...
0
by: Chris | last post by:
I finally got my report to be recongized, that login issue is terrible. Using VS.NET 2003, created report inside of it. Now when I attempt to display the report is blank (missing data, though I can...
14
by: tshad | last post by:
I am trying to set up a reusable library (business component) that I can use in a bunch of my pages. I built the file and it almost compiles, but I am not sure what I am missing. The vbc...
17
by: Justin Emlay | last post by:
I'm hopping someone can help me out on a payroll project I need to implement. To start we are dealing with payroll periods. So we are dealing with an exact 10 days (Monday - Friday, 2 weeks). ...
5
by: le0 | last post by:
Hello guys, Im really having a hard time doing this, I have a record set with the ItemNo field with the data type as Text. In the record that I have, I want to find the missing number in the...
3
by: danceli | last post by:
After loading the BCP files that are created during the trigger/ reporting events I've noticed that the data in the table is missing records. I've also noticed that the missing records (records in...
2
by: danceli | last post by:
I have made trigger on table 'FER' that would be fired if data is inserted, updated to the table. And also, I made batch file using bcp to extract the newly updated / inserted records. But I got...
3
by: Fred Chateau | last post by:
Still working on my XML DataSet... Having moved on past difficult and complex problems, resolved with the assistance of everyone here, I find myself facing yet another problem. My XML document...
15
by: Mr.Tom.Willems | last post by:
Hello people, I am ussing an MS access database to enter and manage data from lab tests. until now i was the only one handeling the data so i had no need for a controle on how missing data was...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.