SECURE A LINKED DATABASE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two databases on a network drive. One is the main database and I use
it all the time. The other is linked to the main database and automatically
updates with the changes that I impute on the main database. I need to make
the second database a read only. How can I do this. I cannot put this
second database on everyones computer. There are over 600 different people
that could access this file and I never know from where. I just want the
second database not able to edit any of the information that is contained in
the Tables, forms, or reports.
 
atwater said:
I have two databases on a network drive. One is the main database and I
use
it all the time. The other is linked to the main database and
automatically
updates with the changes that I impute on the main database. I need to
make
the second database a read only. How can I do this. I cannot put this
second database on everyones computer. There are over 600 different
people
that could access this file and I never know from where. I just want the
second database not able to edit any of the information that is contained
in
the Tables, forms, or reports.
Click to expand...

If you're on an NTFS server couldn't you just set the file's security
attributes as appropriate?

www.keithwilby.com
 
Keith said:
If you're on an NTFS server couldn't you just set the file's security
attributes as appropriate?

www.keithwilby.com

I am on a VNC Server. I have a specific drive that the information needs to be on. I have the database currently there and am able to access it and update all of the information contained inthe database. I have now been asked to make a duplicate that anyone could access as a read only. The Duplicate also needs to be on this certain drive. I have created a folder for the Full access database. I would like to leave the Duplicate out where it is easy to find. I have trided the Access 2002-2003 Security Step by step that is on jmwild.com and I still cannot get the database to ask for a password. I know that I am doing something wrong, but the more that I read, the more confused I get. Thanks for your suggestion. I am new to this security in access and am finding it to be a daunting task. Any suggestions would be greatly appreciated.
Click to expand...
 
I know have the database secured. I have changed my workgroup back to the
default. Now I need to get the database to run on the new workgroup all of
the time without changing the users default workgroup. I have used the
following line in the Target:"K:\DV\DV Database 2005.mdb"/wrkgrp"K:\DV\TCSO
GROUP.mdw" and when I try to apply it I get an error message stating the name
specified in the target box is not valid. I have been reading anything that
I can get my hands on. I have read the Access Security FAQ, your web site
and jmwild web site. Can you tell what I have done in the target line .

Thanks for your patience. I am learning as I go.
 
I have even tried the path" C:\Program File\Microsoft
Office\OFFICE11\MSACCESS.EXE""K:/DV/DV Database 2005.mdb"/wrkgrp"K:\DV\TCSO
GROUP.mdw"
and I still get the message that the C:\Program File ... is not valid. What
in the world am I missing. Thanks for understanding about how a beginner
learns.
 
If your shortcut is exactly what you've typed below, you're missing spaces
between msaccess.exe and the file name, and between the file name and the
/wrkgrp switch.
 
Ok, I just tried putting a space after msaccess.exe" and a space after/wrkgrp
and it still tells me that it is invalid. Please bear with me. It has been
a long week on reading about security. Did I put the spaces in the correct
spot?
 
Back
Top