I want to prevent users from using the tables, and also protect all data in
the database once it is entered via the form. Once the new info is save via
the form we want the data locked from any changes. Is this possible?
So if there are errors in the data they must be cast in stone and left
erroneous forever? <g>
You can set the form's Data Entry property to Yes. This will allow new records
to be entered but old records will not even be visible. With a bit of code in
the form's Current event you can set the form's AllowEdits property to No for
existing records and to Yes for new ones so they can at least see old data.
This will require that the Form is the ONLY route that users have to the data;
for MDB format databases this will require JET Workgroup Security. That
feature has been removed from the newer A2007 .accdb format. See the
Microsoft Access 2000 Security FAQ:
http://support.microsoft.com/kb/207793/en-us
Study it carefully; security is complicated and it's easy to do it wrong. In
addition, a determined and reasonably knowledgable hacker can break almost any
security you can think of; if it's really critical then the data should be
stored in a properly secured SQL/Server instance, not in any desktop database.
