How can I help prevent users from updating any tables by any means other than through forms?
The following technique requires logging on to a “security-enhanced workspace” in code as shown in the following code fragment: Set ws = dbengine.CreateWorkspace(“NewWS”,”DevUser”,”ValidPwd”) Only members of the Admins group may set permissions, so DevUser must be a valid user account in the Admins group and ValidPwd must be a valid password. Warning Using this technique in Microsoft Access 2.0 could compromise the security of your application (see Section 7, “What’s all this about a security hole in Microsoft Access 2.0?”). Security holes in Access 95 also make this technique inadvisable there. In Access 97 and 2000 you can create an MDE, which will help protect security information embedded in your code. If you’re not using Microsoft Access 2.0, or you don’t think your users will stumble on the security hole, these are the steps to follow after removing ALL rights to underlying tables for all users and groups: • Log on as a member of the Admins group. • Create a query that accesses t
