Question Database temporarily stopped adding records.

[craigachan]

I have a split Ac2007 database with a frontend and backend, that is not even close to being max size. The other day, one table quite accepting new records. My frontend forms would just make like it was adding a record, but pooff, the record dissappeard into a black hole without any warning what so ever. I went into the table of suspicion, in the backend db, and manually tried to add a new record, but it wouldnt take a new record. This went on for about 20 minutes. After about 20 minutes of panicking, wondering how many records I had lost during this amount of time, that table started to take new records again. I'm not sure whether this has happened before or not which concerns me.

Has anyone had this experience? Any ideas on what might have happened and what to do? how to prevent this from happening again?

I have to at least come up with some type of warning when records are not being added, but being an amateur programmer, I'm not sure how to do this. Any suggestions?

 

[RuralGuy]

Start using CurrentDB.Execute SQL, dbFailOnError instead of turning your Warnings off. This method does not issue warnings but allows you to see any errors. Turning the warnings off hides the errors too.

 

[craigachan]

Thanks RuralGuy for your help and suggestion. I'm curious what will be the result at runtime? If I get an error will it boot me out of the application that is running and force me to debug? If so, who can I just let the user resume without getting booted out?

Thanks again for your input.

 

[RuralGuy]

Just add error handling to the procedure.