Solved

MS Access Runtime has a lock on the LDB file

Posted on 2011-02-15
12
1,091 Views
Last Modified: 2012-06-27
For years, I have been using MS Access run-time from the Developers Toolkit to let others use databases, forms, reports and macros I've set up.  On some new PCs I've added to the network the database won't open and the LDB file has a lock icon over it.  No error message. Nothing happens. All PCs are using XP.  Why would the LDB file lock on the same level OS on the same network where this has worked for years. The only variable is these are new PCs, but they are running XP.
0
Comment
Question by:leewallin
  • 4
  • 2
  • 2
  • +2
12 Comments
 
LVL 11

Expert Comment

by:RgGray3
ID: 34900848
I belive an LDB always will show with a lock on it's icon...  

That asside...   the fact that some users can not open the file...  have you checked the default open mode of all of your installations?  

Is is possible that someone has the file opened exclusivly?

The fact that there is an LDB file USUALLY indicates that someone has the file open (if the last person out. crashed out...  it might exist even though no one is using it)

0
 
LVL 14

Expert Comment

by:ldunscombe
ID: 34900866
What AV software are they running.  I've had a similar sort of problem with McAfee AV locking files for scanning and failing to release them.

Just a thought

Leigh.
0
 
LVL 11

Expert Comment

by:RgGray3
ID: 34902396
You can use the OpenSchema  to view the users using an mdb

it is based upon the microsoft
cn.OpenSchema(adSchemaProviderSpecific, , "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
Based upon a micosoft article kb 198755

You can see one implementation of the Open Schema on Allen Browne's web site.

http://allenbrowne.com/func-ado.html

My personal implementation of this is based upon a kernal block of code that comes from a commercial provider...  and as such can not and should not post it here.

but basically it allows you to determine UserName, Computer, are they connected and if they have left the database in a suspect state.

Take a look (at Allen browne's site or search for the Ms Kb article)
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 10

Expert Comment

by:Luke Chung
ID: 34915950
I don't know if the anti-advertising 3rd party police are going to jump on me for this but I'm offering a solution that might be helpful and is FREE.

We offer a product, Total Access Admin, http://www.fmsinc.com/MicrosoftAccess/monitor.asp, that lets you monitor who's currently in a database (or multiple databases at once), and log when they enter and leave.

There's a free demo that you can download: http://www.fmsinc.com/MicrosoftAccess/monitor/free-trial.html

Just install it and point to your database and you'll see the activity in real-time. Hope this helps.
0
 
LVL 14

Expert Comment

by:ldunscombe
ID: 34920310
LukeChung

I am not the "anti-advertising 3rd party police", although I don't agree with it. It's the deceptive advertising that I object to.  Specifically the word "FREE".

I just had a look at you're site and the cheapest version is $149.  In what world is that FREE.

Sure there may be a FREE "DEMO VERSION" but that is not the same thing.  It's like saying Paint is free because you can get a free sample pot, or a Movie is free when all you get is the trailer.

Leigh
0
 
LVL 10

Expert Comment

by:Luke Chung
ID: 34923331
This was an attempt to help someone with a specific immediate problem with no intention of receiving any revenue. The solution we offer can be used totally free for 15 days which would be more than sufficient for this need. They don't need to buy it and I don't think they would need to given their limited need.

Someone else mentioned a 3rd party solution that couldn't be shared. So, I thought my actual solution would be welcome compared to that. I'm not aware of alternatives. Sorry for trying to help.
0
 
LVL 10

Expert Comment

by:Luke Chung
ID: 34923335
Oh, the solution is a need to examine the traffic in and out of the LDB to see who's connecting, who's exiting, and who's leaving the lock open in a suspect state.
0
 

Author Comment

by:leewallin
ID: 35060616
Sorry for the delay on the update. Still a problem.  All PCs have the same virus protection.  Older PCs run Run-time version of Access and full Access with multiple users, and have for years. No problem.  This issue involves newly deployed PCs, all on XP. We have our own  network monitoring SW so we know who is in.  2 of us with older PCs got in, no problem.  Went to new PC with us still in, clicked on DB using Run Time - no reaction, no error, just won't open.  2 original got out, it opened OK.  Loaded full version of MS Access on the new PC. With 2 WS in the DB, opened full Access, clicked File Open - opens fine.  Double click on the database, still won't open.; Any ideas?
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 35060702
<< Went to new PC with us still in, clicked on DB using Run Time - no reaction, no error, just won't open.>>

  How long do you leave it sit?  Probably not long enough.  Leave it sit a good 10 or 15 minutes.  And you have to do nothing correct?  No Ctrl/Alt/Del or killing MSACCESS.EXE in task manager?

<<Double click on the database, still won't open.; Any ideas? >>

  Second thing, get someone in the DB, then from the new station with the full Access version, do:

  C:\...\MSACCESS.EXE  C:\....\myapp.MDB /runtime

 replacing the second half there with the actual path and name of your MDB file.

 Does it open like that?

JimD.
0
 
LVL 10

Expert Comment

by:Luke Chung
ID: 35061407
sounds like a Jet incompatibility issue.  Are all the users using the same version of Access?
0
 

Author Closing Comment

by:leewallin
ID: 35333039
Worked perfectly.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Microsoft Access 97 and Delphi XE2 9 50
Dinamic report to Crosstab query 9 31
SetProperty Foreground Colour 5 13
Access/Visual Basic Question 3 23
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question