[ms office - 2010] Users can't create lookup tables with wizard in Access. Permission denied!

[reggiep]

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?

 

thanks