Warning msg: "You are about to delete 0 row(s) from the specified table" -- ZERO!?!? HELLO!?!?
Posted on 2007-03-28
I developed an Access database and it is now in the testing/debugging phase with one user playing with the databsae. The user said that each time she exits the database, she gets a message that pops up saying "You are about to delete 0 row(s) from the specified table." I am perplexed because I have not seen this message and when I open the same file that the user is working on, it doesnt give me the message on my computer. Its only on her computer, what's the deal?
The only thing I could think of was my Appointments table. I have a form that you can use to add appointments/meetings in the Outlook calendar. So I set up a query to delete all rows in the appointments table when the user exits. I added the SetWarning messages in my code and the user is STILL getting the same message when she exits the database.
Private Sub Form_Close()
DoCmd.RunSQL "DELETE * from tblAppointments;"
This was the only thing I could think of because the user wasn't doing any data entry or trying to delete anything or even trying to add an appointment and it's weird to get a message saying, "You are about to delete ZERO rows".....ZERO!?!??! Why is this happening?!?!? Please help!!! This is a difficult challenge for me because I can't test this when I'm not even getting the error message.