I use Access2000 and ASP.Net. All tables are accessible for Insert/Update/Delete except one. I'm getting "Could not update; currently locked." message when I'm trying to INSERT, etc.
I don't understand how it could happen because I usually close all connections immediately and using Try...Catch scheme.
It's all on the hosting server, so I have to call them every time to restart IIS or to restore the database (of course, I always have one day behind data).
Any ideas how I can unlock the table myself?
I don't understand how it could happen because I usually close all connections immediately and using Try...Catch scheme.
It's all on the hosting server, so I have to call them every time to restart IIS or to restore the database (of course, I always have one day behind data).
Any ideas how I can unlock the table myself?
