Hi There,

Can anyone tell me a way of protecting the data stored within a table, so that users cannot inadvertently change or delete data from it???

Best Regards
Keith:(

A table is like a will, someone that shouldn't will get into it.

You can hide the table, set read-only permissions, hide that database widow so that it's not accessible, setup security permissions.

Make the table accessible only through a form (hide the database window, as well as the means to make it visible except for a "back door" for you) and make it non-updatable through the form by setting the following form properties to "no:"

Allow Edits
Allow Additions
Allow Deletions

Someone with still try to get into it.

Fine, but how about linking tables from another database???

A native Access table in an mdb is a table, whether it is linked or not.

Of course, SQL Server and Oracle tables are different, although you also can set .many of their subject attributes.

What I mean is how to deny linking to the tables and changing values?

your best option would be to have all users log in under user names (not admin), add a password to the admin account that only sysadmins know and set the permissions for the table so that admins have total control and non-admins have no control.