Re: Backend Ldb file

From: Roger Carlson (NO-carlsoro-SPAM_at_hotmail.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 10:21:09 -0500

As Doug said, the network rights are EXACTLY the problem. For Access to
work as intended, all users should have Create, Modify, and Delete rights as
well *to the directory* where the BE sits. If a user cannot create the LDB,
Access believes it is opened exclusively.

If it worked before, but stopped suddenly, this can usually be traced back
to some zealous network administrator that says "Hey, they don't need to
delete or modify files in this directory." and set the permissions
accordingly. 

-- 
--Roger Carlson
  www.rogersaccesslibrary.com
  Reply to: Roger dot Carlson at Spectrum-Health dot Org
"Rob" <anonymous@discussions.microsoft.com> wrote in message
news:d72701c40a89$f435a450$a101280a@phx.gbl...
> i've actually narrowed down the problem.  Its not with the
> ldb file, its with the actual program or the server.  The
> problem is when people close out the program/server does
> exit them properly.  If they leave their computer on
> overnight the database locks all but one person out the
> next morning.  I look at the user list in the ldb in the
> morning and it will show 1 user for example, say 'Mike.'
> Now nobody else can get in because, as the error message
> says, the file is already in use.  We then go to 'Heidi's
> computer, which was left on from the previous day, she was
> in the database on the previous day, but is not at work on
> the current day.  We shut down her computer and now
> multiple users are able to access the database.  The
> database does not have an ldb file from the previous day,
> a new one is created in the morning.  My only guess is
> that some record locking file also exists on the personal
> computers of the users.  One other point to note: an ldb
> file is created for the application frontend on the
> server, but not the backend, this is why I'm guessing a
> locking file is created on the pc.  I checked the server
> permissions (novell) on the backend folder and they are
> for read, write, and file scan.  The modify rights are not
> allowed, could this be the problem?
> Thanks,
> Rob
> >-----Original Message-----
> >What are the permissions on the folder where the database
> exists? All users
> >of the database require Read, Write and Change access to
> the folder.
> >
> >-- 
> >Doug Steele, Microsoft Access MVP
> >http://I.Am/DougSteele
> >(No private e-mails, please)
> >
> >
> >
> >"Rob" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:cb2701c409cf$9ba923d0$a501280a@phx.gbl...
> >> I'm having a big problem with my database this morning.
> >> The backend of the application does not create an ldb
> file
> >> anymore.  So now only one person can access the tables
> at
> >> a time.  I don't know what prompted the change, as
> >> everthing worked fine yesterday.  The application is on
> a
> >> server.  Can anyone shed some light on the situation, or
> >> tell me how to rectify the problem?
> >>
> >> Thanks
> >> Rob
> >
> >
> >.
> >

Relevant Pages

  • Re: insert a record
    ... If you create a folder called c:\db and set security rights with Windows ... Explorer to 'change' or 'modify' for the IUSR_computername account, ... you have to move the database into that folder. ... without even the implied warranty of merchantability ...
    (microsoft.public.inetserver.asp.db)
  • Re: What user rights on the server files
    ... You also need Write for Admin users (they need to modify users.txt when ... adding new users in database, etc, or to modify srcsafe.ini when changing ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.vstudio.sourcesafe)
  • RE: Cannot create new forms, reports, or macros
    ... rights is in the database, regardless of whether they have any object open ... > setup to allow only ... >>two persons to modify existing objects in the database. ...
    (microsoft.public.access.forms)
  • Cannot create new forms, reports, or macros
    ... If things seem odd to you, you need to talk to whoever set ... >I have a shared database on our LAN and have user rights ... >two persons to modify existing objects in the database. ...
    (microsoft.public.access.forms)
  • Re: Help with code
    ... If I am in the main menu, then the LDB viewer shows me as not being logged ... > For example, if five concurrent users opened the database, then four of them ... >> Function FindSourceAs String ... >> Dim cat As New ADOX.Catalog ...
    (microsoft.public.access.formscoding)