I have a strange situation, and I'm not sure even where to start
troubleshooting. I have a client who has a small network - 6
workstations, one server running Windows 2003 Server Standard edition.
They have an Access 2003 database that sits on this server. They have no
password protection on the access database - everybody has full access to
it.

We setup shortcuts on each persons desktop to the access database using
UNC paths (instead of mapped drives). The first person double clicks on
the shortcut, the database opens up perfectly. Every other person who
double clicks on the shortcut can't get in - nothing happens. They
double click, and double click and double click but access is not
launched and the database is not opened.

This occurs no matter what order they go into the database - the first
person can always get in by double clicking, but nobody else can. This
occurs whether they double click on the shortcut, or if they navigate
through My Network Places and double click directly on the file.

However - they can always access the database by launching Microsoft
Access, then choosing file->open and finding the database. That works
whether they are the first, second or last one in.

Does anybody have any idea why something like this might happen?

Sincerely,
Matt Schwartz
Nelix, Inc.
matt (AT) nelix (DOT) com
www.nelix.com

Thanks everybody for the great suggestions! Sounds like I should split the
data into a separate database, and change the shortcut to include access in
it.

Thanks again for your help! I greatly appreciate it!

Sincerely,
Matt Schwartz