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

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

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

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
"Mikael Lindqvist" <(E-Mail Removed)> wrote in
message news:AEE924D0-00C5-49D5-80AC-(E-Mail Removed)...
> 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

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
http://mvp.support.microsoft.com/

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

"Mikael Lindqvist" <(E-Mail Removed)> wrote in
message news:03578960-37A0-446A-867D-(E-Mail Removed)...
> 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