Have i broken the database?

Hi there,

I've got some loverly code that is supposed to use some sql to run a
query and output the results to a table for later manipulation.

The problem that occurs is that as the code is running, i can see that
the query is created in the query list but when it is executed, the
query is deleted from the query list and no output is created.

However, if I look in the system objects table, the query is still
listed but doesn't show in the database window.

Is there any known fault or should i just copy everything to a new
database and try again?

Rob.

re: Have i broken the database?

dkintheuk wrote:[color=blue]
> Hi there,
>
> I've got some loverly code that is supposed to use some sql to run a
> query and output the results to a table for later manipulation.[/color]

Can you post this code, please? Also, what version of Access? Is it a
FE/BE configuration? If so, is it an Access BE?

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk

re: Have i broken the database?

Not sure the code is going to help... in fact i resolved this by
retyping ALL the damn code to a new copy of the database... manually...
OUCH.

It must have been a corruption as i've just retyped everything EXACTLY
as it was.

If it ever happens again then i'll post more info.

Rob.