Record insert/delete anomaly

Apr 7, 2016
Reaction score
Hello everyone,

I have the next problem to which I need help to solve.
There is a Workbook with three forms and a Database in Access.

There is a table in the DB called tblPlanungStatus where I record if a module is ready.
All three forms uses the table to either delete or insert a status into it.

There is an anomaly that occurs most of the time from Form3.
I insert the status, it runs without error. I run a query to count the recorords for this type and it comes back 1. Wich is good.
In the DB nothing happens, it shows no record added.
I run the query again and it says there is 1 record.
I run delete and the count says 0. So it seems to work. But in the DB still nothing.

I close the Workbook and run the count again and the record dissapeared, in the DB nothing shows.
If the record stays in the DB then when deleting it works, but after closing it comes back again.

Sometimes the record cannot be added, sometimes it cannot be deleted and when reopening the Workbook (which I don't know why matters) the record either deletes or adds.
In the DB the record appears and dissapears with a certain time, but not always.

I have been stuggling with this for over a week. Can anyone help me?

Thanks, Mike

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question