Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old June 16th, 2008, 01:18 PM
Registered User
 
Join Date: Aug 2005
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access 2007 - High query failure rate

I was wondering if anybody was having the same problem with Access 2007. There is a problem I have not been able to solve when it comes to queries in 2007. I am using a make table query to build a new table based on the sorted records of another. The sorted field contains the values 1 – 2888 long integer values and there are no duplicate values. I can run the same query 10 times and three of those times it will fail to sort properly.
I have run every diagnostic that Microsoft provides and I have the most current updates and service packs on Microsoft Office. I have restarted the system, compacted and repaired the database, and started new databases and yet the problem persists. Anyone else had this problem?


  #2 (permalink)  
Old June 16th, 2008, 03:53 PM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

I don't have Access 2007 (yet) but in general I can tell you that the way the table is sorted will not matter if the query design sorts it another way. Are you saying that the QUERY is not sorting correctly or the TABLE?

If the table, that doesn't matter because people should not be entering the table itself. They should be using a form or report based on the table or query.

If you mean the query is not sorting, are you using it in a report that has sorting and grouping set? If so, those may be overriding the query's sort settings.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
  #3 (permalink)  
Old June 17th, 2008, 08:29 AM
Registered User
 
Join Date: Aug 2005
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This error does not have anything to do with data entry. I've done simple tests on a couple of machines with Office 2007 installed and the results are close. The test I used is a make table query that pulls data from a table with one field that has integer values in it. They go from 1-3000 with no duplicates. I built 10 different tables with a sort that puts the integers in descending order. When I checked the results, 1 to 3 of those tables were not in order.

I find it of great concern that anywhere between 10% and 30% of the queries run are not giving the proper results. If Access 2007 can’t reliably perform a simple sort, what other glitches are in the software that are harder to discover? I am about to uninstall 2007 and go back to Access 2000. I just wanted to see if anyone else had the problem and knows how to fix it.




Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 JohnBoy VB.NET 2002/2003 Basics 1 March 16th, 2008 09:33 PM
Access 2007 Ribbons? bgnetman Access VBA 2 October 30th, 2007 11:03 AM
Design Schemes on Access 2007 mruschetti BOOK: Expert One-on-One Access Application Development 0 October 20th, 2007 07:47 AM
Access 2007 security warning tang_moor Access 1 February 8th, 2007 08:23 AM
Access 2007 - wtf? mmcdonal Access 7 December 19th, 2006 08:45 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.