Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

no access to table

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
0
0
Could anyone help me ?!

one of my tables seems to be defect.

This query
"SELECT COUNT(*) FROM table"
gives me a total number of lines of 7131.

But any attempt to get access to single lines results in a total of 303 lines.

Checking all log-files did not give any server-errors or wrong use by our members.

Does anyone know this problem ?

Tks
 
did you verify if you have any limits in the results sections..
 
Also look for Unique Rows and/or Row limits in the Query Options/properties
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top