Secure a Linked Database

[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.

Thanks in advance for any help.

-Denise

 

[Scott McDaniel]

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.

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

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

 

[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?

Thanks,
Denise

 

[Scott McDaniel]

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?

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

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