I used to have this problem all the time when I was using Access and Cold
Fusion. I don't know if the same solution will work for you but it's worth a
try.
What we used to do to unlock it is send a bad query like Select * from
non-existent table.
Of course, if the database is on a live server and being used then the
unlocked state would not last long. Since Access is file-based, it locks it
while it's in use. It's just the way it works.
Let us know if it works,
Frank
"Aaron" <ku*****@yahoo.com> wrote in message
news:O7**************@TK2MSFTNGP14.phx.gbl...
I wrote a program in c# and oledb for my access database. After each run i
see there's a locked db file in my database folder, it means that my
connection is not closed properly. I did check my code everything seemed
fine. Is there a script or a program that can help me check this? I think
I might have missed something.
Thanks
Aaron