User belongs to 2 groups

[Mark]

If a user say John belongs to two Groups A and B
respectively. Group A can only read the table and Group B
can update the table.

If John logs in to Access, what is his privilege ? Read
Only OR Update ?

If I want John to read the Table on Monday to Wednesday
(On answering enquiry from Customers) and update the Table
on Thursday and Friday (Updating Inventory Record), is
there any advice on how to achieve it ?

Thanks

 

[Scott McDaniel]

John could update the table. Permissions are "least restrictive"

As far as restricting John based on days of the week, you could certainly
write code that would verify the user and day of the week before allowing
access to particular objects ... you could set certain forms to
..AllowEdits=True on Thursday and Friday and .AllowEdits=False on Monday and
Wednesday (again, based on the CurrentUser). There are many good examples of
checking and setting permissions in the Security FAQ, on MSDN, and in the
Jet Programmers Guide.