Recent content by hi2jenny

But I don't see any additional lock created after I opened the Access database or after I opened the report the first time.

Yes, exactly. And I have to exit Access application, not just the database.

Ok, I just tried. It's weird that I had to exit Access application in order to open the form successfully. If I just close the form or even just the database, it pops up with that message. I wonder what kind of lock caused that.

There is a report open when the button on the form is clicked. It always works the first time. After it fails the second time, I have to close the access application and open it again in order to open the form.

What would be the possible reasons? I am the only one using the database so far. Is the lock from SQL server or access database?

Hi, I have a form that consists several buttons. One is to delete a table A, then add records to several tables and eventually it will do a join and insert records to table A, and display a report. It always works while all tables reside in the same Access database. Now we are trying to...