[AccessD] Stored Procedure not producing results

This has been a long time waiting but I think I am getting somewhere.

I have copied the data from the problem database to a good one and 
the sproc works fine.  This indicates that the problem is with the structure.

I created scripts for the tables and views that are involved and 
compared them but they seemed identical.

Is there anything else I should compare?  I could just restore the 
database structure from the good copy but I am curious as to why 
there is the problem.

David

At 23/11/2006, Arthur wrote:
>If the data is the same, the only other possibility is a structure change.
>
>A proviso, which I am unable to document with specific examples, but 
>I have seen this before. Should any query SELECT * FROM SomeTables, 
>then you modify the table(s) of interest, sometimes it gets derailed.
>
>Arthur
>
>----- Original Message ----
>From: David Emerson <newsgrps at dalyn.co.nz>
>To: Access Developers discussion and problem solving 
><accessd at databaseadvisors.com>
>Sent: Wednesday, November 22, 2006 12:56:55 PM
>Subject: Re: [AccessD] Stored Procedure not producing results
>
>I tried:
>
>1) Running the query using dates from 2 months ago
>
>2) Deleting all the data so that it was back to where it was two
>months ago and running the query using dates from 2 months ago.
>
>Neither test worked.  Maybe it is a structure change.  I will try
>comparing tables to see if there is any differences.
>
>David
>
>At 23/11/2006, you wrote:
> >If the structures haven't changed, then the data is the villain. But
> >you have a concrete clue to work from. Devise some scope that will
> >include only the data from two months ago and verify your assertion.
> >Then expand the scope to "two months ago plus a day" and run it
> >again. Repeat until failure.
> >
> >This assumes of course that the scope is expandable so easily. (A
> >good reason to have a "DateEntered" column in every table, which
> >defaults to GetDate()).
> >
> >----- Original Message ----
> >From: David Emerson <newsgrps at dalyn.co.nz>
> >To: Access Developers discussion and problem solving
> ><accessd at databaseadvisors.com>; Access Developers discussion and
> >problem solving <accessd at databaseadvisors.com>
> >Sent: Tuesday, November 21, 2006 10:53:58 PM
> >Subject: Re: [AccessD] Stored Procedure not producing results
> >
> >Worse - my database from two months ago works fine, but the latest
> >version is the one that is causing the problem.  This may indicate a
> >data problem perhaps?
> >
> >David