Can you write protect a table in a database?

[Mikael Lindqvist]

Hi,

I wonder if it's possible to make a table (for all users) write protected (I
don't want people by accident changing data)?

Cheers,
Mikael
Sweden

 

[Mikael Lindqvist]

Well, that's one way to get around the problem.

But I really want to know if it's possible to write-protect the table, and
if so, how?

Cheers,
Mikael

 

[Mikael Lindqvist]

Well, that's one solution to the problem.

But I would really like to know if it's possible to write-protect a table,
and if so, how?

Cheers,
Mikael

 

[Jon Lewis]

If you are using Access 2003 or earlier you can use User Level Security to
have the table 'read only' for certain users. However implementing User
Level Security is complex and is a sledgehammer to crack a nut in this
instance. It's also not supported in the latest version of Access (2007).
Far better practice and easier to use a form to let users view table data as
Jeff suggested.

HTH

 

[Jeff Boyce]

Then don't let your users "see" your table. Access tables store data,
Access forms (and reports) display it.

Use Access forms (and underlying queries) to create read-only views your
users use.

JOPO (Just one person's opinion...)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/