?
Solved

LDB file not created

Posted on 1999-01-14
5
Medium Priority
?
640 Views
Last Modified: 2008-02-07
I have a multi-user access file on a network which can be opened simultaneously by  more than one user.(the shared option is on)
Sometimes, when a user opens it, the LDB file isn't created and the other users can't open it at the same time.  Why is that?

0
Comment
Question by:jeebeedoo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 7

Expert Comment

by:Dedushka
ID: 1973583
Hi, jeebeedoo!

I think, that LDB file not created because database opened in exclusive mode. If users can open this database form Access menu, they can set "Exclusive" check box in "Open" dialog window and lock this database for others.

Best regards,
Dedushka


0
 
LVL 12

Expert Comment

by:Trygve
ID: 1973584
If Dedushkas suggestion does not help try looking into these users permissions on the directory where your mdb is located. A common mistake (I have done it myself) is to think that the users does not need create permissions - they do.
If your users can't create files in the directory Access will not be able to create the ldb file and other users will be prevented from entering the database (like if it was opened exclusivly)
0
 

Author Comment

by:jeebeedoo
ID: 1973585
The users can't open the file in exclusive mode, but the answer provided by Trygve seems to be the only logical answer because the users can't create files in the directory.

Thanks anyway


0
 
LVL 12

Accepted Solution

by:
Trygve earned 800 total points
ID: 1973586
The I guess I can post it as an answer then ?

A common mistake (I have done it myself) is to think that the users does not need create permissions - they do.
If your users can't create files in the directory Access will not be able to create the ldb file and other users will be prevented from entering the database (like if it was opened exclusivly).

Needed permissions (Novell terminology); filescan (to see the file directory), read (to read from the files), write (to write to the files) and create (to be allowed to set valid locking information including creating ldb files if necessary).

0
 

Author Comment

by:jeebeedoo
ID: 1973587
Thank you very much Trygve!  
0

Featured Post

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.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

777 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