Announcement

Collapse
No announcement yet.

Q: OS error 32

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Q: OS error 32

    I am having one which is annoying.
    [quote]Unable to open physical file "path#PRI.MDF". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".

    This is when I try to connect through ADODB from VBA in Excel. SQL Server management Studio can access the file though.

    Is there ANY way I can discover which process, according to XP, is using the file? All apps, files etc are local on my machine. HELP!
    Join MURCs Distributed Computing effort for Rosetta@Home and help fight Alzheimers, Cancer, Mad Cow disease and rising oil prices.
    [...]the pervading principle and abiding test of good breeding is the requirement of a substantial and patent waste of time. - Veblen
    Tags: None
  • #2
    HI Umf

    There's a utility that shows what you want. Search murc for it as it has been mentioned before. Sorry, I don't recall the name.

    T.
    FT.

    Comment

    • #3
      I think this may be it:

      WhoLockMe Explorer Extension v2.0 beta (NT-Win2K-XP) download page
      http://www.dr-hoiby.com/WhoLockMe/
      List all the process locking a file.
      We have enough youth - What we need is a fountain of smart!


      i7-920, 6GB DDR3-1600, HD4870X2, Dell 27" LCD

      Comment

      • #4
        Thx guys. It was the SQL Server Management Studio and/or SQL Server as I had not set the auto lock off or some such property to true. Apparantly, that lock remains after power downs as well...
        Join MURCs Distributed Computing effort for Rosetta@Home and help fight Alzheimers, Cancer, Mad Cow disease and rising oil prices.
        [...]the pervading principle and abiding test of good breeding is the requirement of a substantial and patent waste of time. - Veblen

        Comment

        Previous template Next
        Working...
        X