Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Can't open file because its already running 2003 Access

30 Mar 2017   #1
Keithuk

Windows 7 Professional 32bit SP1
 
 
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.


My System SpecsSystem Spec
.
30 Mar 2017   #2
Keithuk

Windows 7 Professional 32bit SP1
 
 

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 System SpecsSystem Spec
01 Apr 2017   #3
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

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 System SpecsSystem Spec
.

02 Apr 2017   #4
Keithuk

Windows 7 Professional 32bit SP1
 
 

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 System SpecsSystem Spec
02 Apr 2017   #5
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

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 System SpecsSystem Spec
02 Apr 2017   #6
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

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 System SpecsSystem Spec
02 Apr 2017   #7
Keithuk

Windows 7 Professional 32bit SP1
 
 

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 System SpecsSystem Spec
02 Apr 2017   #8
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

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 System SpecsSystem Spec
03 Apr 2017   #9
Keithuk

Windows 7 Professional 32bit SP1
 
 

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 System SpecsSystem Spec
03 Apr 2017   #10
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

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 System SpecsSystem Spec
Reply

 Can't open file because its already running 2003 Access




Thread Tools




Similar help and support threads
Thread Forum
2 Tasks Running and it's not letting me open file location (VIRUS?)
winlogon.exe csrss.exe I tried to open the file location and nothing happens. I googled the files and the 2 MAY be potenttial viruses. Any comments? Maby I hope that they are just normal Win7 Tasks and not viruses Instructions on how to know if they are not viruses. THANKS :D
General Discussion
Open MS Access file
Hi all, I need a little help. We got a new computer in the office and it is running Win 8.1. We also have 2 older computers and they are running win XP. I have them all networked together and everybody can see and edit all files on any computer. So far so good. Here is the problem: MS Access...
Microsoft Office
"Open File - Security Warning" when running a LNK file
Ever since I started using Windows Live Mail, I get the following every time I start it: How do I stop this?
General Discussion
Cannot open file Access is denied message
Hi all. I have a strange issue (or so it seems to me that i am a newbie) . I try to use a small utility which reads massively *.txt files and if they are saved as ANSI it saves them as Unicode. The problem is that when i run it (run as administrator) i get an error message saying "Cannot open...
General Discussion
Put file on desktop -> open file -> access denied?
Hello there. Whenever i take a file and put it onto the my desktop, all the permissions to the file is completely stripped. Leaving none able to open the file. I am able to go into access control and add myself again, but it makes no sense at all.. Why does windows do this and do anyone know...
General Discussion


Our Sites

Site Links

About Us

Find 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 02:57.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App