Access 2003 database copied and pasted

[Guest]

I need to have a copy of my Access 2003 DB on the shared drive at our office.
Coworkers must have access to my records, but I don't want them to be able to
alter my records.

I thought by copying and pasting my DB, it would create a separate DB and if
they changed something, it wouldn't affect me. But, they are linked and any
change they make appears in my DB and vice versa. I tried locking (read-only)
the copy on the shared rive, but it locks mine as well.

I simply right-clicked on my DB file, copied it and then pasted it onto the
shared drive. Is there a way to put a separate copy on this drive?

 

[Wayne Morgan]

If they are truly connecting to a copy of the file, it should have no affect
on your file provided your file is a stand-alone file. If your file is split
into a front-end/back-end setup then the front-end you copied to the share
will still be connected to the back-end, provided the path is recognizable
from the other computer. In that case, yes, they will change the data in the
back-end file that you're using.

The best way to do what you're asking would be to split the database into a
front-end/back-end if it isn't already and use Access Security to give them
read-only permissions to the back-end file. The back-end would contain only
the data tables everything else would be in the front-end file with linked
tables to the back-end file. Each user would get their own front-end file.
This will let the users see the current data as you edit it.

For more information on doing this, see these links.
http://www.granite.ab.ca/access/splitapp/index.htm
http://support.microsoft.com/kb/289885/en-us