Not to sound simplistic, but are all the tables listed in the query
still there (ie, you didn't accidentally delete them yesterday)?

/paul

On 10/28/05, Gary Stetler <[EMAIL PROTECTED]> wrote:
> I am using OO2.0 on a machine running windows 2K.  I started a database
> that now contains a large amount of data in a set of tables, yesterday I
> deleted several tables and queries.  Today when I try to access my
> tables I get the following error message:  If anybody can help I'd
> appreciate it as I really need to get this data and don't want to go
> back to an Access database if I can help it.
>
> Thanks,
> Gary
>
> SQL Status: S1000
> Error code: -78
>
> error in script file line: 19 Table not found in statement [ SELECT
> "cda1results1"."ID", "cda1results1"."well", "joeall"."subjID",
> "joeall"."labID", "cda1results1"."allele_A_rxn",
> "cda1results1"."allele_T_rxn", "cda1results1"."genotype" FROM "joeall"
> "joeall", "cda1results1"]
>
> --
> Gary Stetler, Ph.D.
> Assoc. Director Genotyping Facility
> Institute for Behavioral Genetics
> Univ.Colorado
> 447 UCB
> Boulder CO 80309-0447
> 303-809-5108
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to