Secure a Linked Database

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

Guest

I have an access database on our network, and I want to set another one up
that is linked to the main one, but is read only. I already have the 2nd db
set up, but I need to restrict it to read only.

Thanks in advance for any help.

-Denise
 
I have an access database on our network, and I want to set another one up
that is linked to the main one, but is read only. I already have the 2nd db
set up, but I need to restrict it to read only.
Click to expand...

If you want it readonly for ALL users, then just set the file attribute to ReadOnly (i.e. rightclick the file, select
Properties, then check the ReadOnly box). Note that this action applies to that specific file ONLY ... so if you do
something like restore from a backup, the new file will not necessarily be reset to ReadOnly if the Folder properties
are set to propagate attributes to new files (and if the Folder is NOT set to read only)

Note this also applies to Compacting as well - the newly compacted file may not be ReadOnly, so make sure to check the
file after performing any network maintenance or such.
Thanks in advance for any help.

-Denise
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Scott,

I actually had tried that but that only prevents people from saving
formatting changes, they would still be able to add or delete records, which
would in turn add or delete records in my primary database. I'd like to
restrict them from adding/editing/deleting data in any way. Any other ideas?

Thanks,
Denise
 
Scott,

I actually had tried that but that only prevents people from saving
formatting changes, they would still be able to add or delete records, which
would in turn add or delete records in my primary database. I'd like to
restrict them from adding/editing/deleting data in any way. Any other ideas?
Click to expand...

When you say "primary database", do you mean that you've split the application? If so, then you need to make whatever
changes that are needed on the backend ... if not, then I'm not sure what you're referring to.

If you want to disallow all changes, then implement User Level Security. As Joan said, it won't stop the determined, but
it will put up a big enough roadblock to stop the casual user.

More on ULS: www.jmwild.com, including links to other sites and such.
Thanks,
Denise
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Back
Top