Users can't create lookup tables with wizard in Access. Permission denied!
This whole moving to windows 7 and office 2010 has made me question my whole reason for being!
Office 2010 has a lot of security rightly built into it but it doesn't half cause the humble IT support staff problems.
When a member of teaching staff creates a basic access database and then views a table and goes to design view and then in data type tries to use the lookup wizard they get a permission denied error.
This doesn't happen for admins but I cannot see what it is denying them access to as it is their database in their documents!
Anyone had this before?