Making a shortcut

[Guest]

For the database that I've created for users, I've made a macro in Access
that I create a shortcut on their desktop to open the database. What I want
to know is if there is some way to have this shortcut created only open the
database in a readonly format (if there's some switch to add to the Target
path of a shortcut)?? When the users run this shortcut, the first user that
opens the database gets exclusive access to it; if I want to modify it, I
need to hunt down who that person is so I can make the changes as needed. If
someone is in it in a readonly format and I open it, will I get exclusive
access to do my changes if I don't open it in a readonly format??

 

[Nikos Yannacopoulos]

Buzz,

This is not the way to set-up a multi-user database. The first thing to
do is split (front end with queries, forms, reports, amcros and code)
and back end with the data (tables). Place the BE in a shared folder on
the network, and a copy of the FE on each user's PC (local HDD).
Whenever a change is made, simply re-distribute the new FE.

I suggest you spend some time reading through the multiuser newsgroup,
I'm sure you'll find some interesting stuff in there.

HTH,
Nikos