Database file in use

[Guest]

I am having problems with one of my Access databases in which the database
file is locked and only one user can get in at a time. If anyone else tries
to get into it, it says "file in use." I have not made any changes to the
database, including security, since this problem started or even before it.
The only way to clear the problem is to restart the server. The problem is
then temporarily resolved.

The ldb file for that database is also locked up when this problem happens.
If you try to open it with Word or Notpad, it says "Access denied."

Has anyone else come across this problem?

 

[Guest]

Is that SIU-E or C as in Southern Illinois?

Anyway, the problem is with the permissions on the folder holding the
database file. All users must have Read, Write, Create, and Delete privs on
the entire folder. Not just the .mdb or .ldb file; rather, the entire folder.

 

[Guest]

Actually it is the Southern Illinois U School of Medicine which is where I
work.

I thought I read an article on microsoft that said that but it doesn't make
sense that it would only do it some of the time at random intervals. Right
now it's working and 3 people are in it. It will work for about 2-3 days and
then stop. I don't believe the permissions were changed at the time of the
problem either. It possible a patch changed things though.

I can't check the permissions until Monday because the LAN is out until then.

 

[Aaron Kempf]

MDB is not reliable enough for real world use

not for a single record nor a single user

use Access Data Projects

things like "SQL Profiler" are invaluable.. irreplaceable

 

[Aaron Kempf]

yes, MDB is a pain in the butt

you can find 'JetUtils' at Microsoft.com and they have a LDB viewer

I have heard some people talking about opening LDB with notepad; but I never
liked that.. it seemed too risky

 

['69 Camaro]

Hi, Jeremy.

Actually it is the Southern Illinois U School of Medicine which is where I
work.

Actually, Jerry was asking on which campus you're located, either
Edwardsville or Carbondale. But since the School of Medicine seems to only
have buildings at the Springfield and Carbondale campuses, I suppose SIU-E
isn't one of the choices.

HTH.
Gunny -- Saluki graduate

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Aaron Kempf]

my brother went to carbondale.. for a masters degree in theology or
something along those lines

small world huh

 

[David W. Fenton]

Anyway, the problem is with the permissions on the folder holding
the database file. All users must have Read, Write, Create, and
Delete privs on the entire folder. Not just the .mdb or .ldb file;
rather, the entire folder.

Not true. They don't need delete permission -- they only need
MODIFY.

 

[Guest]

Interesting. I'll have to test that out. Without Delete how does the .ldb
file go away after the last user is out of the database?

 

[Tony Toews [MVP]]

Interesting. I'll have to test that out. Without Delete how does the .ldb
file go away after the last user is out of the database?

It actually doesn't need to go away as any available slots are reused.
And Access didn't delete the ldb file back in 2.0 days. However MS
decided to change that behavior in, I think A95 but for sure in A97
days.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Actually my brother went to SIU-E and my step brother went to SIU-C and I
work at the School of Med in Springfield.

Apparently the only person that can check/change the folder permissions is
gone until Monday. It happened again too so only one person can get in now.
Is there any way to delete the LDB file and allow multiple users with
restarting the server again?

 

[Guest]

In that case I'll have to change my standard advice on this issue. I sure
like that users don't need Full or Delete in the folder as I had a client
who managed to delete an .mdb file.

Thanks!

 

[David W. Fenton]

In that case I'll have to change my standard advice on this issue.
I sure like that users don't need Full or Delete in the folder as
I had a client who managed to delete an .mdb file.

What I've always done is maintained two seperate NT security groups,
one for database users and one for database administrators. I give
the admins full permission, the users only modify (i.e., no delete).
Any time the LDB file develops problems, the admins can delete it
manually or by simply opening the back end exclusively and closing
it.

 

[Aaron Kempf]

yeah

use Access Data Projects and you'll never have to worry about this again

you can use SP_WHO in order to find out who is in a database, and KILL
@@SPID in order to reset a connection

I just grew tired of MDB / LDB crap a decade ago

 

[Aaron Kempf]

you kids are still hosing around with LDB?

I _MUCH_ prefer LDF over LDB; any day of the week