File Lock Icon on Desktop

[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?

 

[Joan Wild]

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.

 

[Melissa]

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

 

[Joan Wild]

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?

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.

 

[Tom Wickerath]

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

_______________________________________________

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?

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.