I want to set permissions inside of folders in a database (Access) so that only certain people can access them. I have a Users Table and a Folder Table and then a concatenated table of Users/Folders that only has a User ID and Folder ID in it. If a user indicates a folder name and a user's email address I want to be able to populate the Users/Folders table with the association.
The code I wrote for this was:
INSERT INTO Folder_Assignment(user_id, menu_item_id)
VALUES ('user_id', 'menu_item_id')
WHERE email_address = '#email_address#"
AND folder_name = '#folder_name#'
But it doesn't seem to work. Am I totally off base with the way I'm doing this or am I close at all?
Anyone have any thoughts?