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?