TPLLimited
asked on
Stop access to raw table in MS Access
Hi
Is there a way to stop someone gaining access to a raw Database Table with MS access so the only method of data input, data manipulation is via a MS Access Form?
Is there a way to stop someone gaining access to a raw Database Table with MS access so the only method of data input, data manipulation is via a MS Access Form?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you using linked tables? If you are, then you can't really control this. Unless you lock down the interface as suggested above, your users will be able to get to the tables, and can always edit them.
You can modify the permissions needed, but be sure to thoroughly test before rolling this out. In many cases, unless you're dealing with an "entry only" app, your users will need more control than just Write.
You can modify the permissions needed, but be sure to thoroughly test before rolling this out. In many cases, unless you're dealing with an "entry only" app, your users will need more control than just Write.
ASKER