ASP.NET, SQL Server, WPF, C#, VB.NET

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?

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 
 
-- 
 
Wayne Morgan 
 
MS Access MVP 
 
"Kira" <knarlee at yahoo dot com(donotspam)> wrote in message 
 
news:326848F9-FA50-4506-91EE-393696CDCFDB@microsoft.com...