Can't open file because its already running 2003 Access

Page 1 of 2 12 LastLast

  1. Posts : 186
    Windows 7 Professional 32bit SP1, Windows 10 Home 64-bit at the moment
       #1

    Can't open file because its already running 2003 Access [Solved]


    Hi guys.

    I've searched for this problem but I haven't seen a good solution.

    I've had a new problem which has developed over the past week. I use MS Office 2003 because it does exactly what I want it to do. I hate the newer Office 2007/2010 because everything is pictures and the database doesn't have the same layout.

    I have Office 2003 on my Windows XP main computer. If I change any info I copy and paste the mdb file back to my laptop. When I try and open this file it says file is already in use by another computer.

    I check Task Manager and its not open. I have to restart the laptop then it opens. I've copied and pasted files for years without any problem.

    Any suggestions would be appreciated.
    Last edited by Keithuk; 22 Apr 2017 at 20:43.
      My Computer


  2. Posts : 186
    Windows 7 Professional 32bit SP1, Windows 10 Home 64-bit at the moment
    Thread Starter
       #2

    I don't know if its related but for the past 7-10 days my Windows XP SP3.

    I have a 1b0110ce97b735b1b2f26448/update folder on Windows XP.

    I know these are temp folders to install updates. When I try and delete this folder it says the file(s) are in use.

    There are 9 files in this folder. kmdfcustom.dll, update.exe, update.ver, update_srv2k3.inf, update_win2k.inf, update_winxp.inf, updatebr.inf, updspapi.dll, wdf01009.cat

    When I run update.exe it shows Microsoft Kernel-Mode Driver Framework Feature 1.9. I click Next and it says:

    https://support.microsoft.com/en-us/...ws-server-2008

    You have successfully completed the Wdf102009 Setup Wizard, click Finish.

    On Windows XP you can't check which updates have been installed as with Windows 7.

    I restart and I still can't delete this temp folder because it says its in use. I run Process Explorer and kmdfcustom.dll isn't listed. Or any files in Task Manager.
      My Computer


  3. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #3

    Did you try compacting and repairing the database before closing and copying? (Had to ask.)

    Have you tried saving it as a backup then moving the backup to open?

    Regards,
    GEWB
      My Computer


  4. Posts : 186
    Windows 7 Professional 32bit SP1, Windows 10 Home 64-bit at the moment
    Thread Starter
       #4

    Thanks for the reply GEWB.

    I use a lot of database Jet 4.0 C:\Program Files\Common Files\microsoft shared\DAO\Dao360.dll v3.60.9756.0 Microsoft DAO 3.6 Object Library in my apps. In settings its set to compact on exit its not easy to repair newer databases. I had a repair function on my old databases.

    This problem only shows on 1 database, all other databases copy over and open.

    https://support.microsoft.com/en-us/help/239114

    I copied the database to another folder but it still won't open as it says it in use. I have to restart my laptop then it opens. The strange thing is why it opens after a restart when its the same file?
      My Computer


  5. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #5

    Hmm, thinking out loud...have you tried opening the file without enabling macros? Umm, are you opening the file using the same user role?

    Regards,
    GEWB
      My Computer


  6. Posts : 4,776
    Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
       #6

    Maybe check the .lbd file. As far as I know it shouldn't exist if no user has opened the database. Since you get a message that the database is in use I'd be inclined to check for the presence of an .ldb file.

    The LDBView Utility
      My Computer


  7. Posts : 186
    Windows 7 Professional 32bit SP1, Windows 10 Home 64-bit at the moment
    Thread Starter
       #7

    I never enable any macros in any databases the lbd file always opens in every database in the folder.
    Thanks again for your suggestions.
      My Computer


  8. Posts : 4,776
    Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
       #8

    With no database open there should not be an .ldb file. If you can see one then there is a problem. I reckon you will have to figure out how to delete the .ldb file then compact and repair all databases.
      My Computer


  9. Posts : 186
    Windows 7 Professional 32bit SP1, Windows 10 Home 64-bit at the moment
    Thread Starter
       #9

    I know the ldb file is created when the database opens and its deleted when its closed. I don't see how the ldb file is a problem.
      My Computer


  10. Posts : 4,776
    Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
       #10

    Okay did you try launching Access from the shortcut or executable then use File > Open then browse to the .mdb file but don't actually open it. If the "Open" dialog box there should be a drop down arrow that lets you choose to "Open Exclusive" or "Open Exclusive Read-Only" - See if that works.
      My Computer


 
Page 1 of 2 12 LastLast

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 14:35.
Find Us