Re: Front End Back End Problems
From: Immanuel Sibero (isiberonospam_at_fivestates.com)
Date: 03/31/04
- Next message: dawn syverson: "access locking problem"
- Previous message: Ron: "Re: you do not have the necessary permissions..."
- In reply to: Steven C: "Re: Front End Back End Problems"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 13:33:41 -0600
Hi Steven,
I'm sure you've got this covered. I would also check and be sure that
everyone has all rights (read, write, delete, modify) on the folder where
the database is. And noone is actually opening the database exclusively. You
can also sort of "watch" the .ldb file and observe its behavior and make
sure it behaves as expected.
For example, if noone is logged on to the database, there should never be an
.ldb file. The first user gets on, an .ldb file has to be created. If one
user gets on and no .ldb file is created, then that user has the database
open exclusively.
HTH,
Immanuel Sibero
"Steven C" <anonymous@discussions.microsoft.com> wrote in message
news:1374e01c41726$6cea3160$a601280a@phx.gbl...
> Each user has there own front end. The primary (daily)
> data is stored in a back end data base. Reference data is
> stored in a second back end data base (Updated annually).
> The problem started after some computers crashed with a
> virus last summer and were taken in by our IT dept. and
> reformated. It seem to straighten out for all computers
> except one. She could not work the same time anyone else
> was on this application. Then we upgrade a computer and
> moved the replacement over to an office that had an even
> older computer. This is when it really got serious and
> will most of the time only let one person at a time in.
> IT people and I have both been searching for what changed
> but have not found it. It is not consistent in what it
> does. Sometimes when we are trying to chase it down we can
> have everyone in there frontends working find with no
> lockouts. Can't ever figure out why the difference
> between when it works and when it doesn't. (I hope we
> find it before I become bald from pulling out my hair.)
> Thanks for the lead.
> Steven
>
> >-----Original Message-----
> >
> >Hi Steven,
> >
> >- Does each user have his/her own front end?
> >- Might want to check the following site, if you havent
> already:
> >
> >http://www.granite.ab.ca/access/tipsindex.htm
> >
> >HTH,
> >Immanuel Sibero
> >
> >
> >
> >"Steven C" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:113cb01c41683$b304f570$a001280a@phx.gbl...
> >> We have an Access db that we have been using for several
> >> years. Recently we are having problems with the users
> >> locking each other out of the tables. The problem is
> not
> >> consistently there making it difficult to trace down a
> >> cause. Can anyone suggest what I might need to be
> looking
> >> for?
> >>
> >> Prior to middle of last summer we did not have this
> >> problem. Even then it was not a frequent thing but now
> is
> >> most of the time. We basicly have 2 to 5 people on the
> >> front ends at any one time. We could have as many as 10.
> >>
> >> Thanks,
> >> Steven C
> >
> >
> >.
> >
- Next message: dawn syverson: "access locking problem"
- Previous message: Ron: "Re: you do not have the necessary permissions..."
- In reply to: Steven C: "Re: Front End Back End Problems"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
