File Lock Icon on Desktop

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

Okay, now this is just weird.
I have two versions of my database on my computer: one is
the actual one, one is a copy I use to figure out
changes. The copy ONLY runs on my computer and is not
linked to anything in the other. I don't have any file
locks (or at least I'm sure I don't), but when I have my
COPY database open, there is a little icon on my desktop
which says it is "Access.LockFile.9" and when I close the
database, it goes away.
This does NOT happen with the other database.

Help?
 
Every time you open a mdb, an associated ldb file is created (unless you
open exclusively). It sounds to me as though the 'copy' database is on your
desktop (i.e. stored there), while the 'other' database is not. Likely the
icon for the 'other' database on your desktop is a *shortcut* to it, rather
than the database file itself.

Shortcuts usually have a small arrow in the lower right of the icon.
 
Yes, the other database is a shoertcut. But I am the ONLY
user of my COPY, so wouldn't that make me the exclusive
user?

I guess it's not a big deal if it's just an inherent
thing.
Thanks,
Melissa
 
Melissa said:
Yes, the other database is a shoertcut. But I am the ONLY
user of my COPY, so wouldn't that make me the exclusive
user?
Click to expand...

No, the ldb file is always created, even if you are the only one that opens
it. If you open the 'other' one i.e. the shortcut, and then open windows
explorer and locate the folder where the mdb is, you'll see there is an ldb
file in that folder.

The only way that the ldb won't be created is if you open it exclusively
i.e. File, Open, and choose Open Exclusive, or you use the /excl switch.

Creation of the ldb is usual and normal behaviour.
 
Creation of the ldb is usual and normal behaviour.

See the following KB article for more information:
Introduction to .ldb Files
http://support.microsoft.com/default.aspx?scid=kb;EN-US;299373

_______________________________________________


Melissa said:
Yes, the other database is a shoertcut. But I am the ONLY
user of my COPY, so wouldn't that make me the exclusive
user?
Click to expand...

No, the ldb file is always created, even if you are the only one that opens
it. If you open the 'other' one i.e. the shortcut, and then open windows
explorer and locate the folder where the mdb is, you'll see there is an ldb
file in that folder.

The only way that the ldb won't be created is if you open it exclusively
i.e. File, Open, and choose Open Exclusive, or you use the /excl switch.

Creation of the ldb is usual and normal behaviour.
 
Back
Top