[AccessD] access security

They can't enter records because you've taken away their write permissions
to the back-end folder - so it looks read-only to them.

The best solution is to use the built in Access security. While it's not
immune to cracking, it will keep busy people who don't have time for hacking
at bay.

Alternatively, just ensure that the users NEVER get to see the database
window and so get direct access to tables and queries where they can delete
things. In your forms you can control  what actions take place quite easily.

Lambert

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of John Eget
> Sent:	Friday, October 29, 2004 10:54 AM
> To:	AccessD at databaseadvisors.com
> Subject:	[AccessD] access security
> 
> I am trying to fix a security issue at my site. My managers like to edit
> or delete records that they think are inappropriate in a product audit
> database and usually fail to inform anyone of this. I have locked them out
> of the backend access by the front end with the directory properties of
> windows for the back end. But this also does not allow them to enter
> records either. But I would also like to take one step further and not
> allow individuals that are entering records into the database from either
> deleting or editing other individual records. Can anyone share with me how
> they may have done this in the past?
> Thanks in advance
> John 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com