Solved

LDB file not created

Posted on 1999-01-14
5
590 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
  • 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 200 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

786 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