I believe there is limited security in msaccess for what you are wanting. I don't believe it is with ado or dao though I think it is ADOX (Microsoft ADO Ext 2.8 For DDL and Security ). YOu would do better either upgrading to sql where you can set security by column for read & write or basically hide the access databasewhere they cannot find it to manipulate it. ( %SYSTEMROOT%\system32\drivers\projectname\data\ ) Just make sure the user has right sto that directory.