Access Record locking file created automaticaly for unlocked datab

[Geoffrey Starr]

How do i stop Microsoft Access from creating a access Record locking file
for an anministrator on my computer who has nothing to do with the database
on my computer and only exists as a place holder for the IT Department.

 

[Jerry Whittle]

Are you talking about an .ldb file? If so when and where does this file show
up?

 

[John W. Vinson]

On Fri, 21 Mar 2008 08:58:00 -0700, Geoffrey Starr <Geoffrey

How do i stop Microsoft Access from creating a access Record locking file
for an anministrator on my computer who has nothing to do with the database
on my computer and only exists as a place holder for the IT Department.

You misunderstand the purpose of the .ldb file. It doesn't "lock the database"
so others cannot use the database; it keeps track of who has the database open
so that you don't have two users attempting to edit the same record in the
same table at the same time. If two users open a .mdb file a .ldb file will be
created.

I have no idea what you mean about "the administrator... who only exists as a
placeholder" though I've known such people. <g> I'm clearly misinterpreting
the sentence but I can't dope out what you DO mean.

 

[George Nicholson]

Unless you are using Workgroup level security, "Admin" is the default
username for ALL users of an Access database.

If you are seeing "Admin" show up in a ldb file, there's a good chance it
has absolutely nothing to do with any user that might use "admin" for a
windows logon.

"Admin" in a ldb file is you (or anyone else who has opened the file),
unless you are using workgroup security.