Protecting entire tables in Access

[Guest]

Hello,
Is there a way to protect entire tables to prevent data changes? I have
tables for annual budget detail. Once the budget is complete I do not want to
allow any changes, but want to allow other users to build and run queries.
Thanks for your help.

 

[Joseph Meehan]

Hello,
Is there a way to protect entire tables to prevent data changes? I
have tables for annual budget detail. Once the budget is complete I
do not want to allow any changes, but want to allow other users to
build and run queries. Thanks for your help.

The database should be secured and split.

You split the database by keeping the tables in one copy on the server
on the LAN and each user gets their own copy of the queries, reports and
forms. They will be able to make all the new queries forms etc they like.

You secure the database using Access Security to keep them from making
data changes.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Guest]

Thank you. I should have mentioned I am not concerned with security issues,
just inadvertant mistakes by 1 or 2 users. Is there another way of
accomplishing this without splitting the database? Can I make a few of the
tables "read only"?
Rob

Hello,
Is there a way to protect entire tables to prevent data changes? I
have tables for annual budget detail. Once the budget is complete I
do not want to allow any changes, but want to allow other users to
build and run queries. Thanks for your help.

The database should be secured and split.

You split the database by keeping the tables in one copy on the server
on the LAN and each user gets their own copy of the queries, reports and
forms. They will be able to make all the new queries forms etc they like.

You secure the database using Access Security to keep them from making
data changes.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Joseph Meehan]

Thank you. I should have mentioned I am not concerned with security
issues, just inadvertant mistakes by 1 or 2 users. Is there another
way of accomplishing this without splitting the database? Can I make
a few of the tables "read only"?
Rob

:

You can accomplish the job without splitting the database, but it is far
better to do so. Sharing a database without splitting is asking for
performance, corruption and other problems.

I suggested the security tools because they can do what you want. The
use of security also provide opportunities for control that you want.

Splitting the database and security are two separate issue and you can
do either without the other.

 

[dbahooker]

if you used Access Data Projects; this would be QUITE easy to do.

don't you wish your database had features like me?

dont you?
dont you?

 

[Joseph Meehan]

if you used Access Data Projects; this would be QUITE easy to do.

don't you wish your database had features like me?

dont you?
dont you?

No.