By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,647 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,647 IT Pros & Developers. It's quick & easy.

File locked by another user

P: n/a
I am using Access 2000 and 2002. I use Access only to create the database
design. Then I move the MDB file to a server where an application connects to
it using ASP.Net.

Occasionally I will create a circumstance where I get "file locked by another
user". I figured out this happens when I overlook a case where the datareader
does not get closed and the connection does get closed. The file then is
locked and the only way to unlock it is to reboot. I am unable to open the
database with ADO or from Windows Explorer. Rebooting clears the file and the
file can be opened again.

Is there a way to clear whatever setting the OS looks at without rebooting?

Jun 25 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Thanks. I will try this the next time I run into the problem.

George

Tom van Stiphout wrote:
>My Computer right-click Manage Shared Folders Open Files

-Tom.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1

Jun 26 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.