Code running behind table? Strange occurance....

[Guest]

Hi,

I have created a frontend/backend database. Certain files are imported to
the frontend database and new records are appended to various tables.

One of the tables seems to be 'funny'. I try and run a query to Append
records to it, but the query doesnt seem to run. I open the table to see if
the query worked, but it hasnt.

When I try and close the table I get the error 'This action will reset the
current code in break mode'.

The strange thing is, there is no code running!!!

I have to go into design view for the table or 'End Task' to close the whole
DB down!

Does any one have any ideas?

Cheers,

Steve.

 

[John Nurick]

Is there a form with a Timer event somewhere in the database - maybe
hidden?

 

[Guest]

There is code running. The code you used to call the append query. Probably:
CurrentDb.Execute("MyAppendQuery")
If this is the case, add this
CurrentDb.Execute("MyAppendQuery"), dbFailOnError

My quess is this is what you are doing. The reason is, this method goes
directly to Jet and without the dbFailOnError will not return an error if it
fails. So, the query has failed and for some reason is not returning
control, so the line of code is still active.

If you use a different method to run the query, post back so we can see how
you are doing it.